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 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?
e. After seeing this revised budget, the production manager cautioned that due to the current production constraint, a complex milling machine, the plant can produce no more than 80,000 units in any one quarter. Is this a potential problem?
No
Yes
Year 2 Quarter | |||||||
a | Description | 1 | 2 | 3 | 4 | Total | |
Budgeted sales (in units) | 45000 | 65000 | 110000 | 70000 | 290000 | ||
Budgeted sales revenue ($7 per unit) | $315000 | $455000 | $770000 | $490000 | $2030000 | ||
Cash collection at 75% in current Quarter | $236250 | $341250 | $577500 | $367500 | $1522500 | ||
Cash collection at 25% in previous Quarter | $65000 | $78750 | $113750 | $192500 | $450000 | ||
Total cash collection from sales | $301250 | $420000 | $691250 | $560000 | $1972500 | ||
Given opening accounts receivable = $65000, cash collected in quarter 1 year 2 | |||||||
b | Total budgeted production for the year under the revised budget | ||||||
Year 2 Quarter | Year 3 Quarter | ||||||
Description | 1 | 2 | 3 | 4 | 1 | Total year 2 | |
Budgeted sales (in units) (A) | 45000 | 65000 | 110000 | 70000 | 80000 | 290000 | |
Closing finished goods inventory (30% of next sales) (B) | 19500 | 33000 | 21000 | 24000 | 27000 | 97500 | |
Opening finished goods inventory © | 12000 | 19500 | 33000 | 21000 | 24000 | 85500 | |
Budgeted production in units (A+B-C) | 52500 | 78500 | 98000 | 73000 | 83000 | 302000 | |
Given opening finished goods inventory 12000 units | |||||||
c | Total cost of raw material purchased for the year under the revised budget | ||||||
Year 2 Quarter | Year 3 Quarter | ||||||
Description | 1 | 2 | 3 | 4 | 1 | Total year 2 | |
Budgeted production (in units) (A) | 52500 | 78500 | 98000 | 73000 | 83000 | 302000 | |
Raw material required in production (5 pounds per unit) (B) | 262500 | 392500 | 490000 | 365000 | 415000 | 1510000 | |
Closing raw material inventory (10% of next production) © | 39250 | 49000 | 36500 | 41500 | - | 166250 | |
Opening raw material inventory (D) | 23000 | 39250 | 49000 | 36500 | - | 147750 | |
Budgeted purchase of raw material (B+C-D)= E | 278750 | 402250 | 477500 | 370000 | - | 1528500 | |
Raw material cost (0.8 per pound) (E*.80) | $223000 | $321800 | $382000 | $296000 | - | $1222800 | |
Given opening raw material inventory 23000 units | |||||||
d | Year 2 Quarter | ||||||
Description | 1 | 2 | 3 | 4 | Total | ||
Budgeted purchase of raw material (A) | 278750 | 402250 | 477500 | 370000 | 1528500 | ||
Raw material cost (0.8 per pound) (B) | $223000 | $321800 | $382000 | $296000 | $1222800 | ||
Cash payment for the current purchase (at 60%) © | $133800 | $193080 | $229200 | $177600 | $733680 | ||
cash payment for the last quarter (at 40%) (D) | $81500 | $89200 | $128720 | $152800 | $452220 | ||
cash disbursement for raw material purchase (C+D) | $215300 | $282280 | $357920 | $330400 | $1185900 | ||
Given opening account payable balance $81500 | |||||||
e | Yes, | ||||||
Total expected cash collection for the year is $1972500 | |||||||
Total required production for the year 302000 units | |||||||
Total cost of raw material to be purchased for the year is $1222800 | |||||||
Expected cash disbursement for raw material for the year si $1185900 |
Requirement 2: The company has just hired a new marketing manager who insists that unit sales can be dramatically increa...
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 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...
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 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...
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 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...
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...
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...