Calculate the total cost per unit for each type of hot tub

Assignment Help Accounting Basics
Reference no: EM131332723

Bubbles Hot Tubs

Bubbles Hot Tubs are a business that manufactures and sells hot tubs to the UK market. At present the business manufactures three different types of hot tubs:

715_Bubbles Hot Tubs.jpg

The selling prices for each of the hot tubs are priced competitively. Selling prices per hot tub are:

 

Selling price

DUO

£1000.00

SQUARE

£2000.00

ROUND

£1500.00

The manufacturing cost is based on the materials used, labour costs and expenses incurred to produce each different type of hot tub.

Bubbles Hot Tubs manufactures the three different hot tubs in separate areas of the production facility as this saves on set up costs and idle time.

The manufacturing costs for the different types of hot tub are provided below:

 

DUO

SQUARE

ROUND

Variable Costs:

 

 

 

Material cost per unit

£115

£400

£250

Labour cost per unit

£200

£400

£300

Expense cost per unit

£150

£250

£200

Fixed Costs:

 

 

 

Production overheads

£115000

£172500

£143000

Other overheads

£20500

£34000

29000

Budgeted capacity

2000

1000

1500

If actual production exceeds 70% of current budgeted capacity for any tub type, the material cost per tub will reduce by 10% due to supplier discounts. Production overheads cover the costs of the production supervisor, warehouse storage, rent, rates, utility bills and insurance, depreciation of machinery. The other overhead charge is to cover the advertising, selling and distribution costs and the product and public liability insurance.

Required:

Calculation of information using excel functionality

1. Produce an excel spreadsheet which calculates and identifies for each type of hot tub at any activity level;

Total Sales Revenue
Total Material Cost
Total Labour Cost
Total Expense Cost
Production Overheads
Other Overheads Profit / (Loss)

2. Use V and/or H look up and/or IF statements where appropriate. Presentation of calculated information using excel functionality

3. Present information in an appropriate layout so the end user can clearly identify the information above at any activity level for any type of hot tub.

4. Use data validation to enable the end user to select a particular hot tub and view the specific information for that hot tub.

Calculations using appropriate formulae

Using the spreadsheet you have created, set the number of units to the budgeted capacity level for each type of hot tub and calculate the following using appropriate formulae.

5. Calculate the total cost per unit for each type of hot tub.

6. Calculate the profit per unit for each type of hot tub.

7. Calculate the profit mark up for each type of hot tub.

8. Calculate the profit margin for each type of hot tub.

Reference no: EM131332723

Questions Cloud

Estimate the mean weight of cream filling : However, the quality control inspectors wish to estimate the mean weight of cream filling more accurately so that they can be 99% confident that it is within 0.25 grams of the true mean. How many donuts should they sample?
Analyze the political social and economic factors : Select two countries, one developed and one emerging, where you would like to invest. Analyze the political, social, and economic factors. Use current research and statistics from reputable sources.
Describe the economic impact of the law : Summarize the major provisions of the law that you chose. Describe the economic impact of the law. Provide specific economic data from credible references. Has the law improved the environment or situation? Provide specific data from credible referen..
Confidence interval for the population proportion : In a survey of 2695 adults, 1479 say they have started paying bills online in the last year. Construct a 99% confidence interval for the population proportion. Interpret the results.
Calculate the total cost per unit for each type of hot tub : Calculate the total cost per unit for each type of hot tub. Calculate the profit per unit for each type of hot tub. Calculate the profit mark up for each type of hot tub. Calculate the profit margin for each type of hot tub.
Desired accuracy in estimating the mean : Assume that past tests have indicated that the standard deviation of the distances the machine hits golf balls is approximately 15 yards. How many golf balls should be hit by the machine to achieve the desired accuracy in estimating the mean?
Human impacts on the sustainability of groundwater : Title: Human Impacts on the Sustainability of Groundwater. Instructions: You will need to write a 1-page lab report using the scientific method to answer the following question: If current human development does not change, will groundwater sustainab..
Construct a belief space in the described situation : Construct a belief space in which the described situation is represented by a state of the world and indicate that state.
Estimates for this statistical analysis : Do these data indicate a significant difference in pain tolerance between the two conditions? Use a two-tailed test withα= .05. Calculate thetwoeffect size estimates for this statistical analysis. You only need to report the values of these two estim..

Reviews

Write a Review

Accounting Basics Questions & Answers

  What are your thoughts on this situationwhat are your

think- what do you think caused or contributed to the recent market meltdown and what can we do to prevent it happening

  Why does a defined benefit plan present far more

Distinguish between a defined benefit plan and a defined contribution plan. Why does a defined benefit plan present far more complex accounting issues than a defined contribution plan?

  Prepare summary journal entries to record i the requisition

stine company uses a job order cost system. on may 1 the company has a balance in work in process inventory of 3750 and

  Installment-sales method and cost-recovery method

On April 1, 2014, Joy Ltd. sold land for $600,000. The note will be collected as follows: $100,000 in 2014, $200,000 in 2015, and $300,000 in 2016. The property had cost Joy $122,000 when it was purchased in 2001.

  Orasco company is considering purchasing new equipment for

1.orasco company is considering purchasing new equipment for 352657. it is expected that the equipment will produce net

  April and may formed a partnership on january 1 2011 april

april and may formed a partnership on january 1 2011. april contributed 180000 cash and equipment with a market value

  Both bond sam and bond dave have 6 percent coupons make

both bond sam and bond dave have 6 percent coupons make semiannual payments and are priced at par value. bond sam has

  Assume that a car dealership wishes to see if efficiency

assume that a car dealership wishes to see if efficiency wages will help improve its salespeoples productivity.

  Furniture plumbing fixtures land goodwill and a trademark

1. daytona corporation a manufacturing corporation aquires the following business assets in the current year furniture

  There are 36 units of the item in the physical inventory at

the units of an available for sale during the year were as followsjan. 1 inventory 42 units at 60mar. 10 purchase 58

  Merchandise costing 8700 was purchased on account with

merchandise costing 8700 was purchased on account with credit terms of .515 n45. two days later merchandise costing

  What is the minimum lump sum cash payment

What is the minimum lump sum cash payment you would be willing to take now in lieu of the ten-year annuity and what is the minimum you would accept

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd