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. Certainly! Here's a transcription and detailed explanation of the document contents:---**Steps to Analyze and Calculate Sales and Commissions:****8. Calculating Monthly Sales Contribution:**- Amir wants to understand each month’s contribution to the total sales. Calculate this as follows: - **a.** In cell B12, enter a formula to divide the total sales for July (cell B9) by the total sales (cell I9). - **b.** Use an absolute reference for cell I9 in your formula. - **c.** Utilize the Fill Handle to extend the formula from cell C12 to G12.**9. Calculating Monthly Commissions:**- Amir needs to determine commissions based on monthly earnings: - For earnings of $275,000 or more, the commission is 26%. - For earnings less than $275,000, the commission is 17%. - Calculate commissions as follows: - **a.** In cell B16, implement an IF function to check if the total sales for July (cell B9) are ≥ 275000. - **b.** If true, multiply total sales for July (cell B9) by 0.26 to find the commission. - **c.** If false, multiply total sales for July (cell B9) by 0.17. - **d.** Use the Fill Handle to apply this formula from B16 to G16 for August through December.**10. Formatting Sparklines:**- Adjust sparklines in range H16:H17 to match the format of Monthly Sales sparklines: - **a.** Switch Column sparklines to Line sparklines. - **b.** Apply the style 'Dark Red, Sparkline Style Accent 1, Darker 50%' from the Sparkline Color theme (first row, first column) for visibility.**11. Increasing Average Clients:**- Amir aims to boost the average number of clients served per month, specifically in retail merchandising, which has low sales. Use Goal Seek to find out the required number of retail clients (cell I23) to reach an average of 35 clients per month: - Change the average clients for all services (cell I26) to 35.**12. Formatting Text:**- Format text in cell J21 for clarity: - **a.** Merge and center the ## Sales and Commissions Report### Net Amount and Commission- **Net Amount for January to June**: - January: $18,599.75 - February: $31,237.96 - March: $20,016.53 - April: $31,186.84 - May: $28,592.61 - June: $33,958.61 - **Total**: $167,591.39- **Net Commission**: 43%### Estimated Sales (Service Category Breakdown)- **Market Research**: - January: $78,000 - February: $79,000 - March: $80,000 - April: $82,000 - May: $84,000 - June: $85,000 - **Total**: $488,500 - **Average Clients**: 40 - **Projections**: 40- **Retail Merchandising**: - January: $58,500 - February: $56,500 - March: $54,000 - April: $52,800 - May: $54,000 - June: $61,000 - **Total**: $332,800 - **Average Clients**: 20 - **Projections**: 20- **Product Promotion**: - January: $81,000 - February: $89,000 - March: $90,000 - April: $90,000 - May: $93,000 - June: $95,000 - **Total**: $539,000 - **Average Clients**: 22 - **Projections**: 22- **Social Marketing**: - January: $52,500 - February: $55,000 - March: $52,000 - April: $59,500 - May: $60,500 - June: $60,500 - **Total**: $340,500 - **Average Clients**: 27 - **Projections**: 27- **Overall Total Sales**: - January

Goal seek is a kind of what-if analysis. When the user wants to know the value of a variable based…

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

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
Outcome and operations are one of the three activities for thinking about analysis. True False
Pls help ASAP
A portfolio can be organized in which of these ways? (Choose all that apply.) Random ☐ Chronological order ☐ Reverse Chronological order Best-First order
1– Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. You must have an excel file with formulas within the cell. 2. Gas & Go is considering offering movie rentals through a self-service company that would locate a machine on the inside of the market store. BlueBox would charge an annual lease fee of $500 for delivery, setup and maintenance, and there is an energy cost of $0.08 for every video rented. GreenFilms would charge an annual lease of only $400, but the energy cost for every video rental is $0.10 due to the larger size of the machine. Customers rent each movie for $1.00, regardless of the company, and the Gas & Go would earn 30% of that revenue for each rental. a. At what volume in number of rental transactions would the two options have the same cost?
Can you tell me what’s the right option
3 Which of the following statements about the evaluation of an investment having uneven cash flows using the payback method is correct? Select one: a. It will produce essentially the same results as those obtained through the use of discounted cash flow techniques. b. It requires the use of a sophisticated calculator or computer software. c. It can be done only by matching cash inflows and investment outflows on a year-by-year basis. d. It CANNOT be done.
Period costs are: a. manufacturing costs that are expensed in the current reporting period. b. costs that are allocated over several accounting periods. c. non-manufacturing costs that are expensed in the current reporting period. d. none of the options are correct.