question 1

material

c) Direct materials purchases budget (9 marks) Fizzy Pop bottles a lemon flavoured soft drink. All inventory is in direct materials and finished goods at the end of each quarter. There is no work-in-process inventory. Fizzy Pop uses cases as the unit of analysis in its budgeting. Each case contains 24 bottles. The business is preparing to build its master budget for the next financial year ending 31 December 2021. The master budget will be based on the following information: i. The target sales for 2021 for each quarter (Q) are: Q1 260,000 cases Q2 240,000 cases Q3 280,000 cases Q4 300,000 cases Q1 (2022) 280,000 cases ii. The selling price for each case is $9 and will be kept constant throughout the year. The beginning finished goods inventory at the start of the first quarter is expected to be 100,000 cases at a cost of $5.30 per case. The inventory manager wants to increase inventory to 135,000 cases at the end of each quarter. iv. . Direct materials for the soft drink include: Syrup - used as flavour for the soft drink. Two (2) litres are required for each case at a cost of $1.20 per litre. At 1 Jan 2021, it is expected that there will be 600,000 litres on hand. Management wants to ensure that at the end of each quarter, inventory on hand is 75% of the following quarter's production needs. Containers - used to bottle the soft drink. Each bottle costs $0.04. Management currently ensures that at the end of each quarter, inventory on hand is 50% of the following quarter's production needs. This will be continued for 2021. Assignment continues on next page ACCT202 2 Assignment continued . Packaging - each case is packed in a cardboard carton (one carton per case). Each carton costs $0.80. At 1 Jan 2021, it is expected that there will be 295,000 cartons on hand. Management wants to ensure that at the start of each quarter, 100% of that quarter's production needs are on hand. No direct material costs are expected to change in 2021