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
-
1 0 7 . The Anglo - Saxon religion was more concerned with ethics than with: a ) Magic b ) Mythology c ) Mysticism d ) Warfare
-
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...
-
There are three sites with the following average wind power densities: site A: 75 W/m2, site B: 500 W/m2, and site C: 800 W/m2. Do you recommend a wind turbine installation for all three sites?...
-
The area of the cross section of an airplane wing has the listed properties about the x and y axes passing through the centroid C. Determine the orientation of the principal axes and the principal...
-
Express the partial comparative income statements that follow as commonsize statements, and comment on the changes from 20x6 to 20x7. (Round computations to one decimal place.) Davis Company Partial...
-
Dean Brothers Corp. owns and operates a steel drum manufacturing plant. Lowell Wyden, the plant superintendent, hired Best Security Patrol, Inc. (BSP), a security company, to guard Dean Property and...
-
6 pts The yields on US Treasury Notes are as follows: \ table [ [ Date , 1 Y r , 2 Y r , 3 Y r , 5 Y r , 7 Y r , 1 0 Y r , 2 0 Y r , 3 0 Y r
-
1. What is the cost of debt for Sunrise Bakery? 2. What is their cost of equity? 3. What is the WACC? 4. Which cost of capital should be used to evaluate the feasibility of the oven purchase? 5....
-
A financial institution has the following portfolio ofover-the-counter options on a share position:TypePosition(# of options)Option DeltaOption GammaOption VegaCall5000.5 0 answers
-
a)Estimate the various financial credit ratios for the company "Pidilite" using publicly available audited financial statements. (6 marks)
-
1. Explain a strategy to structure the strategic planning session for a midsize nonprofit health organization that is competing with several for-profit facilities in the area. 2. Next, determine your...
-
The following table gives GNI measured in both nominal terms and at PPP for three countries. Given this information, what is the correct ordering of these countries in terms of the lowest cost of...
-
1. Harry refuses to respond to being sued because he is upset that his friend Miguel is suing him. Explain the possible consequences of Harry's refusal. 2. John has been served with a subpoena...
-
Dunkin' Donuts uses Proctor & Gamble as an strategic alliance to sell packaged coffees on supermarkets selfs. Could Dunkin' Donuts use strategic alliances to even better advantage than it does now?...
-
Please help me with these two problems Time: 1 hour, 23 minutes, 58 seconds. Question Completion Status: Moving to another question will save trus response. Question 6 Question 6 of 14 Use the...
-
An Atomic Energy Commission nuclear facility was established in Hanford, Washington, in 1943. Over the years, a significant amount of strontium 90 and cesium 137 leaked into the Columbia River. In a...
-
The following are the accounts of Creative Advertising, Inc., an agency that develops marketing materials for print, radio, and television. The agencys first year of operations ended on January 31,...
-
Southwest Airlines Co. is one of the most successful airlines in the United States. Its annual report contains this statement: We are a company of People, not Planes. That is what distinguishes us...
-
Costco Wholesale Corporation is Americas largest membership retail company. According to its letter to stockholders: Our mission is to bring quality goods and services to our members at the lowest...
Study smarter with the SolutionInn App