Homework Help is Here – Start Your Trial Now!
Business
Operations Management
11. Amir would like to increase the average number of clients served per month. Because retail merchandising has the lowest sales, Amir wants to know how many retail merchandising clients he needs to reach the goal of 35 clients served per month. Use Goal Seek to set the average number of clients for all services (cell 126) to the value of 35 by changing the average number of retail merchandising clients (cell 123). 12. Format the text in cell 021 to clarify what it refers to as follows: Merge and center the range 021:326. Rotate the text down in the merged cell. Change the width of column 3 to 7.00. a. b. C.

11. Amir would like to increase the average number of clients served per month. Because retail merchandising has the lowest sales, Amir wants to know how many retail merchandising clients he needs to reach the goal of 35 clients served per month. Use Goal Seek to set the average number of clients for all services (cell 126) to the value of 35 by changing the average number of retail merchandising clients (cell 123). 12. Format the text in cell 021 to clarify what it refers to as follows: Merge and center the range 021:326. Rotate the text down in the merged cell. Change the width of column 3 to 7.00. a. b. C.

Practical Management Science
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter13: Regression And Forecasting Models
Section: Chapter Questions
Problem 39P
See similar textbooks
icon
Related questions
Question
I need help with questions 11 and 12 given on the Word document to show how to do those in Excel and please include the Formulas and make sure to explain how to find the answer for both of those questions.
8. 9. Amir wants to determine how the sales of each month contributed to the total sales. Calculate this information for him as follows: In cell B12, insert a formula without using a function that divides the total sales for July (cell B9) by the total sales (cell 19). Use an absolute reference to cell 19 in the formula. Use the Fill Handle to fill the range C12:G12 with the formula in cell B12. Amir also needs to calculate the commissions paid each month. If the company earns $275,000 or more in a month, the commission is 26% of the sales. If the company earns less than $275,000 in a month, the commission is 17% of the sales. Calculate the commissions as follows: a. b. 12. C. a. b. C. d. a. b. 10. Change the sparklines in the range H16:H17 as follows to use a format similar to the Monthly Sales sparklines: In cell B16, enter a formula that uses the IF function and tests whether the total sales for July (cell B9) is greater than or equal to 275000. a. If the condition is true, multiply the total sales for July (cell B9) by 0.26 to calculate a commission of 26%. b. If the condition is false, multiple the total sales for July (cell B9) by 0.17 to calculate a commission of 17%. 11. Amir would like to increase the average number of clients served per month. Because retail merchandising has the lowest sales, Amir wants to know how many retail merchandising clients he needs to reach the goal of 35 clients served per month. Use the Fill Handle to fill the range C16:G16 with the formula in cell B16 to calculate the commissions for August through December. C. Use Goal Seek to set the average number of clients for all services (cell 126) to the value of 35 by changing the average number of retail merchandising clients (cell 123). Format the text in cell 021 to clarify what it refers to as follows: Merge and center the range 021:026. Rotate the text down in the merged cell. Change the Column sparklines to Line sparklines. Apply the sparkline style Dark Red, Sparkline Style Accent 1, Darker 50% (1st row, 1st column of the Sparkline Color theme palette) to make the sparklines easier to see. Change the width of column 3 to 7.00. 13. Delete row 32 to keep the Estimated Commissions information together.
Transcribed Image Text:8. 9. Amir wants to determine how the sales of each month contributed to the total sales. Calculate this information for him as follows: In cell B12, insert a formula without using a function that divides the total sales for July (cell B9) by the total sales (cell 19). Use an absolute reference to cell 19 in the formula. Use the Fill Handle to fill the range C12:G12 with the formula in cell B12. Amir also needs to calculate the commissions paid each month. If the company earns $275,000 or more in a month, the commission is 26% of the sales. If the company earns less than $275,000 in a month, the commission is 17% of the sales. Calculate the commissions as follows: a. b. 12. C. a. b. C. d. a. b. 10. Change the sparklines in the range H16:H17 as follows to use a format similar to the Monthly Sales sparklines: In cell B16, enter a formula that uses the IF function and tests whether the total sales for July (cell B9) is greater than or equal to 275000. a. If the condition is true, multiply the total sales for July (cell B9) by 0.26 to calculate a commission of 26%. b. If the condition is false, multiple the total sales for July (cell B9) by 0.17 to calculate a commission of 17%. 11. Amir would like to increase the average number of clients served per month. Because retail merchandising has the lowest sales, Amir wants to know how many retail merchandising clients he needs to reach the goal of 35 clients served per month. Use the Fill Handle to fill the range C16:G16 with the formula in cell B16 to calculate the commissions for August through December. C. Use Goal Seek to set the average number of clients for all services (cell 126) to the value of 35 by changing the average number of retail merchandising clients (cell 123). Format the text in cell 021 to clarify what it refers to as follows: Merge and center the range 021:026. Rotate the text down in the merged cell. Change the Column sparklines to Line sparklines. Apply the sparkline style Dark Red, Sparkline Style Accent 1, Darker 50% (1st row, 1st column of the Sparkline Color theme palette) to make the sparklines easier to see. Change the width of column 3 to 7.00. 13. Delete row 32 to keep the Estimated Commissions information together.
X File 2 Pr AutoSave 127 Home Paste Ready Off H SC EX19 3b JeffreyWang 2 v Insert X D S TUDOMITU V 17 Net Amount 18 Net Commission % 19 20 21 27 28 29 30 31 32 33 Net Commission % 34 59°F Rain coming Draw Amount Net Amount Service Category 22 Market research $ 23 Retail merchandising $ 24 Product promotion $ 25 $ Social marketing Total 26 Gill Sans MT $ Undo Alignment Font Clipboard IN Fy (i) SUBSCRIPTION CANCELLED On Sunday, December 18, 2022, most features of Excel will be disabled. vix ✓ fx Page Layout BIU-A- $ $ $ Documentation Accessibility: Investigate B 1,500.LI 13 18,599.75 $ 43% January 78,000 $ 58,500 $ 81,000 $ 52,000 $ 269,500 $ January 4,581.50 $ 1,970.05 $ Formulas Data Α' Α' 43% Sales Report V с TEVIO.11 31,237.96 $ February + == = 三三三四五 Review 79,000 $ 56,500 $ 89,000 $ 55.000 $ 279,500 $ February 7,267.00 $ 3,124.81 $ View D Help 2Wrap Text ...... 4 20,015.63 $ March O Search (Alt+Q) 80,000 $ 50,000 $ 90,000 $ 56,000 $ 276,000 $ Merge & Center March 7,176.00 $ 3,085.68 $ E Reactivate Estimated Sales April Fy 4 TAIVATON 31,186.84 $ 82,000 $ 52,800 $ 91,000 $ 58,000 $ 283,800 $ Estimated Commissions April 7,378.80 $ 3,172.88 $ General $%9 F Fa Number ←800 -0 V 32,592.61 $ May 84,000 $ 54,000 $ 93,000 $ 59,500 $ 290,500 $ May 7,553.00 $ 3,247.79 $ hp Fy G H F Cell Conditional Format as Formatting Table Styles Styles 7771539 33.958.61 June 85,500 $ 61,000 $ 95,000 $ 60,000 $ 301,500 $ June 7,839.00 3,370.77 H Total 488,500 332,800 539,000 340,500 1,700,800 Trend W $ Insert Delete Format $ T $ Cells Avg. Clients - HH avriFTIL 167,591.39 Total V 40 20 22 27 Jeffrey Wang 41,795.30 17,971.98 Help 14 6 Projections JW 2.48 480 Sort & Find & Filter Select Editing K Commen D Analyze Data Analysis L
Transcribed Image Text:X File 2 Pr AutoSave 127 Home Paste Ready Off H SC EX19 3b JeffreyWang 2 v Insert X D S TUDOMITU V 17 Net Amount 18 Net Commission % 19 20 21 27 28 29 30 31 32 33 Net Commission % 34 59°F Rain coming Draw Amount Net Amount Service Category 22 Market research $ 23 Retail merchandising $ 24 Product promotion $ 25 $ Social marketing Total 26 Gill Sans MT $ Undo Alignment Font Clipboard IN Fy (i) SUBSCRIPTION CANCELLED On Sunday, December 18, 2022, most features of Excel will be disabled. vix ✓ fx Page Layout BIU-A- $ $ $ Documentation Accessibility: Investigate B 1,500.LI 13 18,599.75 $ 43% January 78,000 $ 58,500 $ 81,000 $ 52,000 $ 269,500 $ January 4,581.50 $ 1,970.05 $ Formulas Data Α' Α' 43% Sales Report V с TEVIO.11 31,237.96 $ February + == = 三三三四五 Review 79,000 $ 56,500 $ 89,000 $ 55.000 $ 279,500 $ February 7,267.00 $ 3,124.81 $ View D Help 2Wrap Text ...... 4 20,015.63 $ March O Search (Alt+Q) 80,000 $ 50,000 $ 90,000 $ 56,000 $ 276,000 $ Merge & Center March 7,176.00 $ 3,085.68 $ E Reactivate Estimated Sales April Fy 4 TAIVATON 31,186.84 $ 82,000 $ 52,800 $ 91,000 $ 58,000 $ 283,800 $ Estimated Commissions April 7,378.80 $ 3,172.88 $ General $%9 F Fa Number ←800 -0 V 32,592.61 $ May 84,000 $ 54,000 $ 93,000 $ 59,500 $ 290,500 $ May 7,553.00 $ 3,247.79 $ hp Fy G H F Cell Conditional Format as Formatting Table Styles Styles 7771539 33.958.61 June 85,500 $ 61,000 $ 95,000 $ 60,000 $ 301,500 $ June 7,839.00 3,370.77 H Total 488,500 332,800 539,000 340,500 1,700,800 Trend W $ Insert Delete Format $ T $ Cells Avg. Clients - HH avriFTIL 167,591.39 Total V 40 20 22 27 Jeffrey Wang 41,795.30 17,971.98 Help 14 6 Projections JW 2.48 480 Sort & Find & Filter Select Editing K Commen D Analyze Data Analysis L
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 13 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
SEE MORE TEXTBOOKS