Solution a:
Schedule of expected cash collection | |||||
Particulars | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Year |
Accounts receivables beginning | $65,000.00 | $65,000.00 | |||
Cash received for Q1 Sale | $262,500.00 | $87,500.00 | $350,000.00 | ||
Cash received for Q2 Sale | $341,250.00 | $113,750.00 | $455,000.00 | ||
Cash received for Q3 Sale | $630,000.00 | $210,000.00 | $840,000.00 | ||
Cash received for Q4 Sale | $367,500.00 | $367,500.00 | |||
Budgeted Cash Collection | $327,500.00 | $428,750.00 | $743,750.00 | $577,500.00 | $2,077,500.00 |
Solution b:
Production Budget | ||||||
Particulars | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Year | Quarter 1, next year |
Budgeted sales unit | 50000 | 65000 | 120000 | 70000 | 305000 | 80000 |
Add: ending inventory (30% of next quarter sales) | 19500 | 36000 | 21000 | 24000 | 24000 | 27000 |
Less: Beginning inventory | 12000 | 19500 | 36000 | 21000 | 12000 | 24000 |
Estimated production unit | 57500 | 81500 | 105000 | 73000 | 317000 | 83000 |
solution c:
Budgeted Cost of raw material purchases | |||||
Particulars | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Year |
Budgeted Production units | 57500 | 81500 | 105000 | 73000 | 317000 |
Raw material per unit (In Pounds) | 5 | 5 | 5 | 5 | 5 |
Total requirement of raw materials | 287500 | 407500 | 525000 | 365000 | 1585000 |
Add: Desired ending inventory (10% of next quarter production needs) | 40750 | 52500 | 36500 | 41500 | 41500 |
Less: Beginning inventory | 23000 | 40750 | 52500 | 36500 | 23000 |
Budgeted purchase units of raw material (In Pounds) | 305250 | 419250 | 509000 | 370000 | 1603500 |
Raw material cost per pound | $0.80 | $0.80 | $0.80 | $0.80 | $0.80 |
Budgeted cost of purchases | $244,200.00 | $335,400.00 | $407,200.00 | $296,000.00 | $1,282,800.00 |
Solution d:
Schedule of expected cash disbursement for merchandise purchases | |||||
Particulars | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Year |
Accounts Payable, Beginning | $81,500.00 | $81,500.00 | |||
Q1 Purchases | $146,520.00 | $97,680.00 | $244,200.00 | ||
Q2 Purchases | $201,240.00 | $134,160.00 | $335,400.00 | ||
Q3 Purchases | $244,320.00 | $162,880.00 | $407,200.00 | ||
Q4 Purchases | $177,600.00 | $177,600.00 | |||
Total payments | $228,020.00 | $298,920.00 | $378,480.00 | $340,480.00 | $1,245,900.00 |
I'm having trouble solving this accounting problem and would greatly appreciate some help please! Requirement 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: 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...
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 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 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...
This is all one question, please help! 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 Budgeted unit sales Selling price per unit 4 Year 2 Quarter 2 3 70,000 105,000 1 45,000 $7 Year 3 Quarter 1 2 90,000 90,000 70,000 3 Data Year 3 Quart 4...
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 Chapter 8 Form worksheet is to be used to create your own worksheet version of the Review Problem in the text. 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: Requirement 2: The company has just hired a new marketing manager who insists that unit sales...
А Chapter 8: Applvina Excel Data Year 2 Quarter Year 3 Quarter 4 2 60,000 Budgeted unit sales 40,000 100,000 50,000 70,000 80,000 • Selling price per unit • Accounts receivable, beginning balance • Sales collected in the quarter sales are made • Sales collected in the quarter after sales are made • Desired ending finished goods inventory is • Finished goods inventory, beginning • Raw materials required to produce one unit • Desired ending inventory of raw materials is...