This is all one question, please help!
Homework Answers
| SALES BUDGET | |||||||||
| Q1 | Q2 | Q3 | Q4 | Year | Q1 | Q2 | |||
| Budgeted Sales units | 45,000 | 70,000 | 1,05,000 | 70,000 | 2,90,000 | 90,000 | 90,000 | ||
| Selling price per unit | 7 | 7 | 7 | 7 | 7 | 7 | 7 | ||
| Total Sales | 3,15,000 | 4,90,000 | 7,35,000 | 4,90,000 | 20,30,000 | 6,30,000 | 6,30,000 | ||
| EXPECTED CASH COLLECTIONS | |||||||||
| Q1 | Q2 | Q3 | Q4 | Year | |||||
| Beginingg Accounts receivable | 65,000 | 65000 | |||||||
| Q1 Sales | 2,36,250 | 78750 | 315000 | ||||||
| Q2 Sales | 367500 | 122500 | 490000 | ||||||
| Q3 Sales | 5,51,250 | 1,83,750 | 735000 | ||||||
| Q4 Sales | 3,67,500 | 367500 | |||||||
| Total Cash Collections | 3,01,250 | 4,46,250 | 6,73,750 | 5,51,250 | 1972500 | ||||
| PRODUCTION BUDGET | |||||||||
| Q1 | Q2 | Q3 | Q4 | Year | Q1 | Q2 | |||
| Budgeted Sales Units | 45,000 | 70,000 | 1,05,000 | 70,000 | 2,90,000 | 90,000 | 90,000 | ||
| Add: Desired Ending Finished inventory | 21,000 | 31,500 | 21,000 | 27,000 | 27,000 | 27,000 | |||
| Total Needs | 66,000 | 1,01,500 | 1,26,000 | 97,000 | 3,17,000 | 1,17,000 | |||
| Less: Beginning Finished Inventory | 12,000 | 21,000 | 31,500 | 21,000 | 12,000 | 27,000 | |||
| Required Production in units | 54,000 | 80,500 | 94,500 | 76,000 | 3,05,000 | 90,000 | |||
| RAW MATERIAL PURCHASE BUDGET | |||||||||
| Q1 | Q2 | Q3 | Q4 | Year | Q1 | ||||
| Budgeted Production units | 54,000 | 80,500 | 94,500 | 76,000 | 3,05,000 | 90,000 | |||
| RM required per unit | 5 | 5 | 5 | 5 | 5 | 5 | |||
| Total RM requiremnt | 2,70,000 | 4,02,500 | 4,72,500 | 3,80,000 | 15,25,000 | 4,50,000 | |||
| Add: Desired Ending Inventory | 40,250 | 47,250 | 38,000 | 45,000 | 45,000 | ||||
| Total needs | 3,10,250 | 4,49,750 | 5,10,500 | 4,25,000 | 15,70,000 | ||||
| Less: Beginning Inventory | 23,000 | 40,250 | 47,250 | 38,000 | 23,000 | ||||
| Purchase Units | 2,87,250 | 4,09,500 | 4,63,250 | 3,87,000 | 15,47,000 | ||||
| Cost price per unit | 0.80 | 0.80 | 0.80 | 0.80 | 0.80 | ||||
| Budgeted Purchase in $ | 2,29,800 | 3,27,600 | 3,70,600 | 3,09,600 | 12,37,600 | ||||
| EXPECTED CASH PAYMENTS | |||||||||
| Q1 | Q2 | Q3 | Q4 | Year | |||||
| Beginning Accounts payable | 81,500 | 81,500 | |||||||
| Q1 Purchase | 1,37,880 | 91920 |
Know the answer?
Add Answer to:
|
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 1 2 Budgeted unit sales 45,000 70,000 115,000 65,000 90,000 90,000 Selling price per unit ST A B C D E F G 1 Chapter 8: Applying Excel...
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...
The
comlany 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.
a. What are the total expevted cash collections for the year
under the revised budget?
b. What is the total required production for the year under
the revised budget?
c. What is the total cost of raw materials to be...
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...
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...
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...