Spaworks Inc. makes hot tubs for residential use. The hot tubs, which consist of a fibreglass...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Spaworks Inc. makes hot tubs for residential use. The hot tubs, which consist of a fibreglass finish and proprietary insulation glass, are sold with an all-weather pump and heater unit for $2,750. The company is planning its annual budget for the coming year ending October 31, 2020, and the controller has provided the following data: Sales F2020 15,000 tubs November sales: 1,800 tubs; December sales: 1,500 tubs F2021 Selling price per tub: $2,750.00 Materials and labour requirements (per tub) Direct materials Insulation Fibreglass Pumps Direct labour 5.0 kg 10.4 sq. metre (m2) 1 unit 8 hours Inventories Qty Units Cost Beginning: Finished goods 550 unit $1,400.00 Direct materials Insulation 2,195 kg m2 $15.00 Fibreglass Pumps 6,500 $12.00 $850.00 550 unit Ending finished goods inventory is 25% of next month's sales. Ending direct materials inventories are 20% of next month's production needs. Direct materials inventory is expected to change to the following: $ 16.00 per kg $ 13.00 per square metre $900.00 per unit Insulation Fibreglass Pumps Other rates Direct labour wage rate Variable manufacturing overhead Variable marketing costs Number of customers $22.50 per hour $26.00 per direct labour hour $250 per customer 15,000 Other costs Fixed manufacturing overhead Fixed non-manufacturing costs $319,275 $1,250,000 Required: Prepare the following schedules of the master budget for the year ended October 31, 2020. Assume that the company uses first in, first out (FIFO) for inventory costs: a) Revenue budget b) Production budget c) Direct materials usage budget d) Direct materials purchases budget Spaworks Inc. makes hot tubs for residential use. The hot tubs, which consist of a fibreglass finish and proprietary insulation glass, are sold with an all-weather pump and heater unit for $2,750. The company is planning its annual budget for the coming year ending October 31, 2020, and the controller has provided the following data: Sales F2020 15,000 tubs November sales: 1,800 tubs; December sales: 1,500 tubs F2021 Selling price per tub: $2,750.00 Materials and labour requirements (per tub) Direct materials Insulation Fibreglass Pumps Direct labour 5.0 kg 10.4 sq. metre (m2) 1 unit 8 hours Inventories Qty Units Cost Beginning: Finished goods 550 unit $1,400.00 Direct materials Insulation 2,195 kg m2 $15.00 Fibreglass Pumps 6,500 $12.00 $850.00 550 unit Ending finished goods inventory is 25% of next month's sales. Ending direct materials inventories are 20% of next month's production needs. Direct materials inventory is expected to change to the following: $ 16.00 per kg $ 13.00 per square metre $900.00 per unit Insulation Fibreglass Pumps Other rates Direct labour wage rate Variable manufacturing overhead Variable marketing costs Number of customers $22.50 per hour $26.00 per direct labour hour $250 per customer 15,000 Other costs Fixed manufacturing overhead Fixed non-manufacturing costs $319,275 $1,250,000 Required: Prepare the following schedules of the master budget for the year ended October 31, 2020. Assume that the company uses first in, first out (FIFO) for inventory costs: a) Revenue budget b) Production budget c) Direct materials usage budget d) Direct materials purchases budget
Expert Answer:
Answer rating: 100% (QA)
Revenue budget Expected sales in units 15000 x Selling price per tube 27... View the full answer
Posted Date:
Students also viewed these general management questions
-
The Davis family of Atlanta, Georgia, is planning its annual summer vacation. Three vacation locations along with criteria weights and location ratings follow. What is the recommended...
-
The National Collegiate Lacrosse Association is planning its annual national championship tournament. It selects 16 teams from conference champions and the highest ranked at-large teams to play in...
-
The Hartford Symphony Guild is planning its annual dinner-dance. The dinner-dance committee has assembled the following expected costs for the event: The committee members would like to charge $35...
-
Using Dirac delta functions in the appropriate coordinates, express the following charge distributions as three-dimensional charge densities p(x). (a) In spherical coordinates, a charge Q uniformly...
-
This exercise is an extension of Exercise 2-3A. Assume John Sullivan completed the following additional transactions during February. Show the effect of each transaction on the basic elements of the...
-
I.C. Cream is considering two possible expansion plans. Proposal A involves opening eight stores in northern Alaska at a total cost of $4,000,000. Under another strategy, Proposal B, I.C. Cream would...
-
Organizations often use multiple pricing objectives. Locate an organization that uses several pricing objectives, and discuss how this approach influences the companys marketing mix decisions. Are...
-
Multiple Choice Questions Select the best answer for each of the following and explain fully the reason for your selection. a. Which of the following is least likely to be considered an inherent risk...
-
Here are the shopping times (in minutes) for a sample of 17 shoppers at a particular computer store: 26, 23, 44, 41, 38, 35, 31, 37, 37, 34, 34, 31, 31, 27, 27, 27, 24 Send data to calculator Draw...
-
Barlow Company manufactures three products: A, B, and C. The selling price, variable costs, and contribution margin for one unit of each product follow: The same raw material is used in all three...
-
Instructions Consider an organization that has Earnings Before Tax of $100,000. Assume amortization expense for this organization is zero, and it is in the 30% tax bracket. Answer the following...
-
Coles Group has $50 million capital, which includes $15 million debt. Shareholders' required rate of return is 7% p.a. Cost of debt is 5%. Calculate Coles Group's Weighted Average Cost of Capital....
-
Henrietta made monthly deposits of $1000 at the end of each month into an account paying 6% compounded monthly for 8 years. She then left the funds in the account for an additional 35 years. How much...
-
It is very important in business for companies to determine their profit in different situations Profit is revenue (money earned) minus costs (money spent). A company's revenue earned for selling x...
-
Coles Group has $50 million capital, which includes $15 million debt. Shareholders' required rate of return is 7% p.a. Cost of debt is 5%. $2 million of debt has been repaid when due. Interest...
-
1. Why is valuing diversity and social justice the most important in becoming a global citizen? 2. Describe two events that illustrate the development of global citizenship based on valuing...
-
You are hired as a financial manager at O'HARA CORPORATION, a lamp manufacturing company. You are required to provide your recommendations in respect to the acquisition of a new production plant....
-
What is the order p of a B + -tree? Describe the structure of both internal and leaf nodes of a B + -tree.
-
What is are the key elements of the BCG matrix?
-
What are Porters generic strategies?
-
What is the link between the balanced scorecard and strategy?
Study smarter with the SolutionInn App