DPK Co is a company established over 5 years ago in Salthill, Co. Galway. It was...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
DPK Co is a company established over 5 years ago in Salthill, Co. Galway. It was formed by two sisters who saw a gap in the market for organic body products such as face and body wash, face cream and shampoos. The sisters were keen to grow the business in a sustainable way therefore the key input to their products was seaweed - available in abundance along the coast and with a close proximity to the business. They sold their products within the Irish, UK and wider European markets. The company employs a management accountant who has been busy preparing budgets for the period from October to December 2023 and is currently compiling pertinent information relating to one of the company's newest products: Sea-mist. Sea-mist is a refreshing facial spray based on two key organic ingredients: mineral water and seaweed extract. There is a simple manufacturing process and the product is manufactured in a 500ml size for everyday use. Details relating to this productare shown below. 1. Projected sales for the last quarter of 2023 (unit = 500ml bottle size) Month Sales units October 4,300 November 4,800 December 5,000 The projected selling price for the 500ml bottle of Sea-mist is 6.50. 2. The budgeted costs to produce one bottle of Sea-mist is as follows: Materials Mineral water (400ml) 0.32 Seaweed extract (100ml) 0.60 Recycled plastic bottle 0.15 Labour (0.2hr @9.50 per hour) 1.90 Variable production overhead 0.45 Total cost 3.42 The company has arranged to purchase top-quality mineral water at a cost of 0.80 per litre and seaweed extract at a cost of 5.00 per litre. These prices have been fixed from 2020 until 2024. 3. At1 October 2023, the company expects to have the following opening inventory: Sea-mist (500ml bottles) | 950 bottles Mineral water 2,500litres Seaweed extract 1,500litres Recycled Plastic bottles 1,200 bottles 4. Estimated closing inventory of finished goodsand raw materials are outlined below: Inventory item End October End November End December Sea-mist (500ml bottles) | |1,200 1,700 2,200 Mineral water (litres) 2,800 3,010 4,120 Seaweed extract (res) 1,800 Recycled Plastic bottles 1,300 1,800 2,000 1,500 800 Requirement (a) Prepare a total sales budget (in units and ) units for the quarter ending 31st December 2023. 2Marks (b) Prepare a total production budget inunits for the quarter ending 31st December 2023. 4 Marks (c) Prepare a total materials purchase budget (in units and ) for each material for the quarter ending 31st December 2023. 15 Marks (d) Prepare a total labour cost budget (in hours and for the quarter ending 31st December 2023. 2 Marks (e) Prepare a total variable overhead cost budget for the quarter ending 31st December 2023. DPK Co is a company established over 5 years ago in Salthill, Co. Galway. It was formed by two sisters who saw a gap in the market for organic body products such as face and body wash, face cream and shampoos. The sisters were keen to grow the business in a sustainable way therefore the key input to their products was seaweed - available in abundance along the coast and with a close proximity to the business. They sold their products within the Irish, UK and wider European markets. The company employs a management accountant who has been busy preparing budgets for the period from October to December 2023 and is currently compiling pertinent information relating to one of the company's newest products: Sea-mist. Sea-mist is a refreshing facial spray based on two key organic ingredients: mineral water and seaweed extract. There is a simple manufacturing process and the product is manufactured in a 500ml size for everyday use. Details relating to this productare shown below. 1. Projected sales for the last quarter of 2023 (unit = 500ml bottle size) Month Sales units October 4,300 November 4,800 December 5,000 The projected selling price for the 500ml bottle of Sea-mist is 6.50. 2. The budgeted costs to produce one bottle of Sea-mist is as follows: Materials Mineral water (400ml) 0.32 Seaweed extract (100ml) 0.60 Recycled plastic bottle 0.15 Labour (0.2hr @9.50 per hour) 1.90 Variable production overhead 0.45 Total cost 3.42 The company has arranged to purchase top-quality mineral water at a cost of 0.80 per litre and seaweed extract at a cost of 5.00 per litre. These prices have been fixed from 2020 until 2024. 3. At1 October 2023, the company expects to have the following opening inventory: Sea-mist (500ml bottles) | 950 bottles Mineral water 2,500litres Seaweed extract 1,500litres Recycled Plastic bottles 1,200 bottles 4. Estimated closing inventory of finished goodsand raw materials are outlined below: Inventory item End October End November End December Sea-mist (500ml bottles) | |1,200 1,700 2,200 Mineral water (litres) 2,800 3,010 4,120 Seaweed extract (res) 1,800 Recycled Plastic bottles 1,300 1,800 2,000 1,500 800 Requirement (a) Prepare a total sales budget (in units and ) units for the quarter ending 31st December 2023. 2Marks (b) Prepare a total production budget inunits for the quarter ending 31st December 2023. 4 Marks (c) Prepare a total materials purchase budget (in units and ) for each material for the quarter ending 31st December 2023. 15 Marks (d) Prepare a total labour cost budget (in hours and for the quarter ending 31st December 2023. 2 Marks (e) Prepare a total variable overhead cost budget for the quarter ending 31st December 2023.
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
respond to the instruction using the following criteria: Individual Written Case Exercise Respond to the specific questions provide in the case document it will be seven documents. Please make sure...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Describe how you plan to allocate your budget to each promotional activity. Provide a brief rationale. First, when developing a marketing budget plan, you want to start with the total budget...
-
Consider two locations with the same wind speed and ambient air temperature but one location is at a higher altitude than the other. Which location has more wind power potential? Why?
-
In Problems 718, match each graph to one of the following functions: A. y = x + 2 B. y = C. y = x + 2 x + 2 D. y = -x + 2 E. y = (x - 2) Fy=(x + 2) G. y = x - 2 H. y = -x + 2| I. y = 2x J. y = -2x K....
-
Explain the difference between design, analysis, and patterns.
-
Hall-Mark regularly supplied electronic parts to Peter Lee. On September 11, 1992, Lee gave Hall-Mark a $100,000 check for parts it had received. Hall-Mark continued to ship parts to Lee. On...
-
Hazelnut Corporation manufactures lawn ornaments. It currently has two product lines, the basic and the luxury. Hazelnut has a total of $169,122 in overhead. The company has identified the following...
-
Chapter 26: The Aggregate Demand-Aggregate Supply Model ePage(s) 837-838 26.3. What is aggregate supply? What is the meaning of a leftward shift in the long-run aggregate supply (LRAS) curve? Click...
-
6. The bank is offering you a new saving which will give you a 2% real annual interest rate. If the inflation rate is 5% annually how long will it take you to double your money both in nominal and...
-
How to construct a repricing model with market yield percentages and duration years? Explain. How to construct a duration model?
-
You need $500,00 in 10 years. How much do you need to invest in a bank account that earns 4% today to have the $500,000 in 10 years?
-
1. Consider the following security. It pays $300 next year, and then $400 in every year forever after that (see timeline of payments below). Interest rates are 4% at all maturities. What is the fair...
-
Newton Bay is a sparsely populated area. The government plans to build an international airport there and announces this plan publicly. When hotel chains learn about the airport, they become...
-
The following questions pertain to the discussions on the Case Study 3 Deere Cost Management. 1. Do we have enough information to estimate Saunders costs? What other data do you want and where would...
-
The population of Detroit, Michigan, decreased from 1,027,974 in 1990 to 688,701 in 2013 (Source: U.S. Census Bureau). Find the average rate of change in the population of Detroit, Michigan, over the...
-
Use the \(\gamma\)-matrices in the Weyl representation to show that the Dirac equation (14.31) is equivalent to Eq. (14.25). Data from Eq. 14.31 Data from Eq. 14.25 (y"Pu-m)(p) = (iy" - m)(p) = 0
-
Prove that the boosted right-handed spinor \(\psi_{\mathrm{R}}(\boldsymbol{p})\) is related to the corresponding rest spinor by Eq. (14.21).
-
Prove the identity \((\sigma \cdot \boldsymbol{p})^{2}=\mathrm{I}^{(2)} p^{2}\), where \(\sigma=\left(\sigma_{1}, \sigma_{2}, \sigma_{3} ight)\) are the Pauli matrices, \(\boldsymbol{p}\) is the...
Study smarter with the SolutionInn App