Requirement 2: The company has just hired a new marketing manager who insists that unit sales...
Fantastic news! We've Found the answer you've been seeking!
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/6657d39db74ea_8376657d39dac1f8.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/6657d39eb1982_8386657d39e4324d.jpg)
Transcribed Image Text:
Requirement 2: The company has just hired a new marketing manager who insists that unit sales can be dramatically increased by dropping the selling price from $8 to $7. The marketing manager would like to use the following projections in the budget Data Budgeted unit sales Selling price per unit Year 2 Quarter 1 45,000 2 65,000 105,000 65,000 $7 Year 3 Quarter 1 85,000 100,000 L Chapter 8: Applying Excel 2 3 Data 4 5 Budgeted unit sales 6 7 Selling price per unit A B C D E F G Year 3 Quarter 1 2 3 4 1 2 45,000 65,000 105,000 65,000 85,000 100,000 $ 7 per unit $ 65,000 75% 25% B Accounts receivable, beginning balance 9. Sales collected in the quarter sales are made 10 Sales collected in the quarter after sales are made 11 Desired ending finished goods inventory is 12 Finished goods inventory, beginning 13 Raw materials required to produce one unit 14 Desired ending inventory of raw materials is 15 Raw materials inventory, beginning 30% of the budgeted unit sales of the next quarter 12,000 units 5 pounds 10% of the next quarter's production needs 23,000 pounds 16 Raw material costs $ 080 per pound 17 Raw materials purchases are paid 16. and 60% in the quarter the purchases are made 40% in the quarter following purchase 19 Accounts payable for raw materials, beginning balance S 81,500 Requirement 2: The company has just hired a new marketing manager who insists that unit sales can be dramatically increased by dropping the selling price from $8 to $7. The marketing manager would like to use the following projections in the budget Data Budgeted unit sales Selling price per unit Year 2 Quarter 1 45,000 2 65,000 105,000 65,000 $7 Year 3 Quarter 1 85,000 100,000 L Chapter 8: Applying Excel 2 3 Data 4 5 Budgeted unit sales 6 7 Selling price per unit A B C D E F G Year 3 Quarter 1 2 3 4 1 2 45,000 65,000 105,000 65,000 85,000 100,000 $ 7 per unit $ 65,000 75% 25% B Accounts receivable, beginning balance 9. Sales collected in the quarter sales are made 10 Sales collected in the quarter after sales are made 11 Desired ending finished goods inventory is 12 Finished goods inventory, beginning 13 Raw materials required to produce one unit 14 Desired ending inventory of raw materials is 15 Raw materials inventory, beginning 30% of the budgeted unit sales of the next quarter 12,000 units 5 pounds 10% of the next quarter's production needs 23,000 pounds 16 Raw material costs $ 080 per pound 17 Raw materials purchases are paid 16. and 60% in the quarter the purchases are made 40% in the quarter following purchase 19 Accounts payable for raw materials, beginning balance S 81,500
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
At the balance sheet date Clarkson Company held title to goods in transit amounting to $214,000. This amount was omitted from the purchases figure for the year and also from the ending inventory ....
-
Banner Corporation purchased all of the common stock of Dwyer Company at underlying book value and uses the equity method in accounting for its investment. Balance sheet information provided by the...
-
Discuss the nature of risk and explain why it is important in the context of investment decisions.
-
1. How do information technologies contribute to the business success of Sew What? Inc.? Give several examples from the case regarding the business value of information technology that demonstrate...
-
How do responsibility reports differ from budget reports?
-
Your firm, Nurse International has identified investments for your hospital in long term, fixed income bonds. Your boss is expecting you to complete a comprehensive, analytical, response to this...
-
Question 37 Plantito Inc., produces potted plants. For next year, Pietro predicts that 45,000 units will be produced, with the following total costs: Direct materials Direct labor ? 80,000 Variable...
-
When you are to design a data transmission system, you have two key considerations to work with: data rate and distance, with emphasis placed on achieving the highest data rates over the longest...
-
How much work does a supermarket checkout attendant do on a can of soup he pushes 0.600 m horizontally with a force of 5.00 N? Express your answer in joules and kilocalories. 3 . (a) Calculate the...
-
Suppose in its income statement for the year ended June 30, 2022, The Clorox Company reported the following condensed data (dollars in millions). Salaries and wages expenses$460 Research and...
-
Consider the extensive form game show in the figure below. How many strategies does Player 2 have in this game? (2,2,1) b (2,4,2) 03 by 03 02 dz (4.2,0) (2.0.2) (0.3.4) (3,5,3) (3,1,2)
-
2a. Elasticity and total revenue The following graph illustrates the weekly demand curve for motorized scooters in Madison. Use the green rectangle (triangle symbols) to compute total revenue at...
-
Which statement is least appropriate? There is an abundance of material on the advantages of standardization and a number of features can be highlighted: a. The most familiar standardized procedures...
-
Insert the missing word: There appears to be a direct conflict between the extent of direction and standardization that a comprehensive audit manual provides, and the auditors professional . . . . ....
-
Which statement is least appropriate? Audit manuals fulfil the following roles: a. Defining standards and methods of work. b. Communicating this to auditors. c. Establishing a base from which to...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App