Answered step by step
Verified Expert Solution
Question
1 Approved Answer
a. What are the total expected cash collections for the year under this revised budget? b. What is the total required production for the year
a. | What are the total expected cash collections for the year under this revised budget? |
b. | What is the total required production for the year under this revised budget? |
c. | What is the total cost of raw materials to be purchased for the year under this revised budget? |
d. | What are the total expected cash disbursements for raw materials for the year under this revised budget? |
15.00 points 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 Year 2 Quarter Year 3 Quarter 50,000 65,000 115,000 75,000 85,000 95,000 Budgeted unit sales Selling price per unit $7 per unit 1 Chapter 8: Applying Excel 3 Data Year 2 Quarter Year 3 Quarter Budgated unit sales 50,000 65,000 115,000 75,000 95,000 95,000 7 -Soling proe per unit 7 por unit $65,000 8Accounts receivable, beginning balance 9Sales collected in the quarter sales are made 0Sales collected in the quarter aftor sales are made 11 Desred ending finished goods inventory is 2 Finished goods invantory, boginning 13Raw materials required to produce one unit 14Desired ending inventory of raw materials is 15% 25% 30% of the budgeted unit sales of the next quarter 12,000 units 5 pounds 10% of the next quarters production needs 23,000 pounds Raw materials inventory, beginning 6Raw mateial costs 7Raw materials purchases are pald 1 and 19 Accounts payable for raw materals, beginning balance 20 $0.80 per pound 60% in the quarter the purchases are made 40% in the quarter folowing purchase $81.500 15.00 points 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 Year 2 Quarter Year 3 Quarter 50,000 65,000 115,000 75,000 85,000 95,000 Budgeted unit sales Selling price per unit $7 per unit 1 Chapter 8: Applying Excel 3 Data Year 2 Quarter Year 3 Quarter Budgated unit sales 50,000 65,000 115,000 75,000 95,000 95,000 7 -Soling proe per unit 7 por unit $65,000 8Accounts receivable, beginning balance 9Sales collected in the quarter sales are made 0Sales collected in the quarter aftor sales are made 11 Desred ending finished goods inventory is 2 Finished goods invantory, boginning 13Raw materials required to produce one unit 14Desired ending inventory of raw materials is 15% 25% 30% of the budgeted unit sales of the next quarter 12,000 units 5 pounds 10% of the next quarters production needs 23,000 pounds Raw materials inventory, beginning 6Raw mateial costs 7Raw materials purchases are pald 1 and 19 Accounts payable for raw materals, beginning balance 20 $0.80 per pound 60% in the quarter the purchases are made 40% in the quarter folowing purchase $81.500
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started