A)Quarter 1 = 50000units *7*0.75(current year)= 262500 + 65000 ( opening Accounts Receivable Balance = 327500
Quarter 2 = 350000*0.25 + 65000*0.75*7= 422500
Quarter 3 = 455000*0.25+735000*0.75=113750+551250=655000
Quarter 4 = 75000*0.75*7+735000*0.25= 577500
Total = 1982500 Collection from sale of goods and subsequent and current cash collections
B)
Q1 | Q2 | Q3 | Q4 | Q1 | |
Current Quarter sales | 50000 | 65000 | 105000 | 75000 | 85000 |
Closing inventory 30% of projected sales of next quarter |
19500 | 31500 | 22500 | 25500 | |
less- op inventory | -12000 | -19500 | -31500 | -22500 | |
Production per quarter | 57500 | 77000 | 96000 | 78000 | |
therefore total equals | 308500 |
c)
Production per quarter | 57500 | 77000 | 96000 | 78000 | 86500 |
Raw material required | 287500 | 385000 | 480000 | 390000 | 432500 |
Closing 10% of next quarter | 38500 | 48000 | 39000 | 43250 | |
less- opening | -23000 | -38500 | -48000 | -39000 | |
Total purchased(pounds) | 303000 | 394500 | 471000 | 394250 | |
cost 0.8$ | 242400 | 315600 | 376800 | 315400 |
Total Cost | 1250200 |
D)
Total purchased(pounds) | 303000 | 394500 | 471000 | 394250 |
cost 0.8$ | 242400 | 315600 | 376800 | 315400 |
60% of current quarter | 145440 | 189360 | 226080 | 189240 |
40% of previous Quarter | 61500 | 58176 | 75744 | 90432 |
Total payment | 206940 | 247536 | 301824 | 279672 |
Total Cash Disbursements | 1035972 |
e)Yes since because a set of cash flow assumptions depend on the fact that production would be above 80000units in Q3 and Q4
The company has just hired a new marketing manager who insists that unit sales can be...
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 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...
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...
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 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 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...
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...
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...