Answer (A) $ 2,016,250
Answer (B) 310,000 Units
Answer (C) $ 1,257,600
Answer (D) $ 1,220,300
Answer (E) Yes it is an potential problem
Budget | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Quarter 1 | Quarter 2 |
Budgeted Unit Sales | 45000 | 70000 | 115000 | 65000 | 90000 | 90000 |
Selling Price | 7 | 7 | 7 | 7 | 7 | 7 |
Account Receivable Beginning | 65000 | 78750 | 122500 | 201250 | 113750 | 157500 |
Addition | 315000 | 490000 | 805000 | 455000 | 630000 | 630000 |
Cash Received | 301250 | 446250 | 726250 | 542500 | 586250 | 630000 |
Account Receivable Ending | 78750 | 122500 | 201250 | 113750 | 157500 | 157500 |
Finish Goods Beginning Bal | 12000 | 21000 | 34500 | 19500 | 27000 | 27000 |
Manufactured UNITS | 54000 | 83500 | 100000 | 72500 | 90000 | 90000 |
Sold | 45000 | 70000 | 115000 | 65000 | 90000 | 90000 |
Closing Bal | 21000 | 34500 | 19500 | 27000 | 27000 | 27000 |
Raw Material Beginning Bal | 23000 | 41750 | 50000 | 36250 | 45000 | 45000 |
Purchsed UNITS | 288750 | 425750 | 486250 | 371250 | 450000 | 450000 |
Utilised for Manufacturing | 270000 | 417500 | 500000 | 362500 | 450000 | 450000 |
Closing Bal | 41750 | 50000 | 36250 | 45000 | 45000 | 45000 |
Account Payable Begin | 81500 | 92400 | 136240 | 155600 | 118800 | 144000 |
Purcheses | 231000 | 340600 | 389000 | 297000 | 360000 | 360000 |
Paid | 220100 | 296760 | 369640 | 333800 | 334800 | 360000 |
Closing Balance | 92400 | 136240 | 155600 | 118800 | 144000 | 144000 |
Requirement 2: The company has just hired a new marketing manager who insists that unit sales...
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: Year 3 Quarter Year 2 Quarter Data 1 2 Budgeted unit sales 45,000 65,000 115,000 70,000 Selling price per unit $ 7 80,000 100,000 | 1 Chapter 8: Applying Excel Data 1 45,000 2 65,000 3 115,000 Year...
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: Year 2 Quarter Year 3 Quarter Data 1 2 3 4 1 2 Budgeted unit sales 50,000 65,000 115,000 75,000 90,000 100,000 Selling price per unit $7 1 2 3 4 5 6 7 8 9 10 11...
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: Year 2 Quarter Year 3 Quarter Data Budgeted unit Sales Selling price per unit 50,000 70.000 115,000 5,000 85,000 100.000 D Chapter 8: Applying Excel Data Year 3 Quarter 5 Budgeted unit sales 50.000 70,000 115,000 60,000 $5,000...
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: Year 2 Quarter Year 3 Quarter Data Budgeted unit sales Selling price per unit 50, eee $7 65, eee 110,eee 70, eee 90, eee 180, eee 1 Chapter 8: Applying Excel 3 Data Year 3 Quarter 5 Budgeted...
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: Year 2 Quarter Year 3 Quarter Data 1 2 3 4 1 2 Budgeted unit sales 50,000 65,000 120,000 65,000 80,000 90,000 Selling price per unit $7 1 2 3 4 5 6 7 8 9 10 11 12 13...
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: Year 2 Quarter Year 3 Quarter Data 1 2 3 4 1 2 Budgeted unit sales 45,000 65,000 105,000 60,000 90,000 100,000 Selling price per unit $7 8 9 10 11 12 13 14 15 16 17 18 19 Chapter...
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: Year 2 Quarter Year 3 Quarter Data 1 2 3 4 1 2 Budgeted unit sales 45,000 65,000 110,000 70,000 80,000 90,000 Selling price per unit $7 a. What are the total expected cash collections for the year...
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: Year 2 Quarter Year 3 Quarter Data 1 2 3 4 1 2 Budgeted unit sales 50,000 70,000 105,000 75,000 80,000 95,000 Selling price per unit $7 Chapter 8: Applying Excel Data Year 3 Quarter 1 2 3 4 1...
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: Year 2 Quarter Year 3 Quarter Data 1 2 3 4 1 2 Budgeted unit sales 50,000 70,000 110,000 60,000 90,000 100,000 Selling price per unit $7 a. What are the total expected cash collections for the year...
please help this is due tonight! thank you! Check my work 2 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: Part 2 of 2 Year 2 Quarter Year 3 Quarter Data Budgeted unit sales Selling price per unit 50,000 65,000 105,000 65,000 85,00 95,000 15 $7...