Paramel Beverages bottles two soft drinks under licence to Cadaver Ltd at its Newcastle plant Bottling at this plant is highly repetitive, automated process Empty bottles are removed from their carton, placed on a conveyor, and cleaned, rinsed, dried, filled, capped and heated (to reduce condensation) The only stock held is direct materials or else finished goods There is no work in process The two soft drinks bottled by Paramel Beverages are lemonade and diet lemonade The syrup for both soft drinks is purchase from Cadaver Ltd Syrup for the regular brand contains a higher sugar content than the syrup for the diet brand Paramel Beverages uses a lot size of 1,000 cases as the unit of analysis in its budget (Each case contains 24 bottles) Direct materials are expressed in terms of lots, where one lot of direct materials is the input necessary to yield one lot (1,000 cases) of beverage In 2010, the following purchase prices ae forecast for direct materials Syrup Containers (bottles, caps, etc ) Packaging Lemonade $1,200 per lot $1,000 per lot $800 per lot Diet Lemonade $1,100 per lot $1,000 per lot $800 per lot The two soft drinks are bottled using the same equipment The equipment is cleaned daily, but it is only rinsed when a switch is made during the day between diet lemonade and 2 lemonade Diet lemonade is always bottled first each day to reduce the risk of sugar contamination The only difference in the bottling process for the two drinks is syrup Summary data used in developing budgets for 2010 are as follows a b c d e Sales Lemonade, 1080 lots at $9,000 selling price per lot Diet lemonade, 540 lots at $8,500 selling price per lot Opening (1 January 2010) stock of direct materials Syrup for lemonade, 80 lots at $1,100 purchase price per lot Syrup for diet lemonade, 70 lots at $1,000 purchase price per lot Containers, 200 lots at $950 purchase price per lot Packaging, 400 lots at $900 purchase price per lot Opening (1 January 2010) stock of finished goods Lemonade, 100 lots at $5,300 per lot Diet lemonade, 50 lots at $5,200 per lot Target closing (31 December 2010) stock of direct materials Syrup for lemonade, 30 lots Syrup for diet lemonade, 20 lots Containers, 100 lots Packaging, 200 lots Target closing (31 December 2010) stock of finished goods Lemonade, 20 lots Diet lemonade, 10 lots f Each lot requires 20 direct manufacturing labour hours at the 2010 budgeted rate of $25 per hour Indirect manufacturing labour costs are included in the manufacturing overhead budget g Variable manufacturing overhead is forecast to be $600 per hour of bottling time bottling time is the time the filling equipment is in operation It takes 2 hours to bottle 3 one lot of lemonade and 2 hours to bottle one lot of diet lemonade Fixed manufacturing overhead is forecast to be $1,200,000 for 2010 h Hours of budgeted bottling time is the sole allocation base for all fixed manufacturing overheads I Administration costs are forecast to be 10 of the cost of goods manufactured for 2010 Marketing costs are forecast to be 12 of sales for 2010 Distributions costs are forecast to be 8 of sales for 2010 Required Assume Paramel Beverages uses the first in first out (FIFO) method of costing all stock On the basis of the preceding data, prepare the following budgets (in units and or dollars as 1 2 3 4 5 6 7 8 9 10 11 12 applicable) for 2010 Revenue budget (3 marks) Production budget (3 marks) Direct material usage budget (15 marks) Direct material purchase budget (10 marks) Direct manufacturing labour budget (6 marks) Manufacturing overhead cost budget (15 marks) Closing finished goods stock budget (10 marks) Cost of goods sold budget (3 marks) Marketing cost budget (1 mark) Distribution cost budget (1 mark) Administration cots budget (7 marks) Budgeted profit loss (6 marks) So my question is, shouls I put 100 for Container and 200 for Packaging in Ending Inventory as the question said Diet lemonade is always bottled first each day to reduce the risk of sugar contamination

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 01, 2024

Paramel Beverages bottles two soft drinks under licence to Cadaver Ltd. at its Newcastle plant. Bottling at this plant is highly repetitive, automated process. Empty

Paramel Beverages bottles two soft drinks under licence to Cadaver Ltd. at its Newcastle plant. Bottling at this plant is highly repetitive, automated process. Empty bottles are removed from their carton, placed on a conveyor, and cleaned, rinsed, dried, filled, capped and heated (to reduce condensation). The only stock held is direct materials or else finished goods. There is no work in process.

The two soft drinks bottled by Paramel Beverages are lemonade and diet lemonade. The syrup for both soft drinks is purchase from Cadaver Ltd. Syrup for the regular brand contains a higher sugar content than the syrup for the diet brand.

Paramel Beverages uses a lot size of 1,000 cases as the unit of analysis in its budget. (Each case contains 24 bottles). Direct materials are expressed in terms of lots, where one lot of direct materials is the input necessary to yield one lot (1,000 cases) of beverage. In 2010, the following purchase prices ae forecast for direct materials:

Syrup Containers (bottles, caps, etc.) Packaging

Lemonade

$1,200 per lot $1,000 per lot $800 per lot

Diet Lemonade

$1,100 per lot $1,000 per lot $800 per lot

The two soft drinks are bottled using the same equipment. The equipment is cleaned daily, but it is only rinsed when a switch is made during the day between diet lemonade and

lemonade. Diet lemonade is always bottled first each day to reduce the risk of sugar contamination. The only difference in the bottling process for the two drinks is syrup.

Summary data used in developing budgets for 2010 are as follows:

Sales

Lemonade, 1080 lots at $9,000 selling price per lot
Diet lemonade, 540 lots at $8,500 selling price per lot

Opening (1 January 2010) stock of direct materials
Syrup for lemonade, 80 lots at $1,100 purchase price per lot
Syrup for diet lemonade, 70 lots at $1,000 purchase price per lot
Containers, 200 lots at $950 purchase price per lot
Packaging, 400 lots at $900 purchase price per lot

Opening (1 January 2010) stock of finished goods
Lemonade, 100 lots at $5,300 per lot
Diet lemonade, 50 lots at $5,200 per lot

Target closing (31 December 2010) stock of direct materials
Syrup for lemonade, 30 lots.
Syrup for diet lemonade, 20 lots.
Containers, 100 lots.
Packaging, 200 lots.

Target closing (31 December 2010) stock of finished goods
Lemonade, 20 lots.
Diet lemonade, 10 lots.

f Each lot requires 20 direct manufacturing labour hours at the 2010 budgeted rate of $25 per hour. Indirect manufacturing labour costs are included in the manufacturing overhead budget.
g Variable manufacturing overhead is forecast to be $600 per hour of bottling time; bottling time is the time the filling equipment is in operation. It takes 2 hours to bottle

one lot of lemonade and 2 hours to bottle one lot of diet lemonade. Fixed manufacturing overhead is forecast to be $1,200,000 for 2010.

h Hours of budgeted bottling time is the sole allocation base for all fixed manufacturing overheads.

I Administration costs are forecast to be 10% of the cost of goods manufactured for 2010. Marketing costs are forecast to be 12% of sales for 2010. Distributions costs are forecast to be 8% of sales for 2010.

Required:

Assume Paramel Beverages uses the first in first out (FIFO) method of costing all stock. On the basis of the preceding data, prepare the following budgets (in units and/or

dollars as

1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12.

applicable) for 2010:

Revenue budget (3 marks) Production budget (3 marks) Direct material usage budget (15 marks) Direct material purchase budget (10 marks) Direct manufacturing labour budget (6 marks) Manufacturing overhead cost budget (15 marks) Closing finished goods stock budget (10 marks) Cost of goods sold budget (3 marks) Marketing cost budget (1 mark) Distribution cost budget (1 mark) Administration cots budget (7 marks) Budgeted profit & loss. (6 marks)

So my question is, shouls I put 100 for Container and 200 for Packaging in Ending Inventory as the question said " Diet lemonade is always bottled first each day to reduce the risk of sugar contamination."