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...
-
Why does the contemporary view of procurement as a strategic activity differ from the more traditional view of "purchasing?"
-
1. ABC has issued a $1000 par bond with 25 years to maturity, 7% coupon rate, and semi-annual payments. Calculate the present value if the bond if the YTM is 7%. 2. How would the answer to #1 change...
-
The chapter provides sample goals for an initial sales call on a prospect. (a) What other goals can you come up with that might be appropriate for an initial sales call? (b) Develop three or four...
-
For no apparent reason, a poodle is running at a constant speed of v ~ 5.00 m/s in a circle with radius R = 2.50 m. Let VI be the velocity vector at time t" and let V2 be the velocity vector at time...
-
Analyse effective leadership strategies for enhancing performance in public enterprises. Use practical examples from the Namibian corporate sector to illustrate your answers.
-
Consider the state diagrams of Figure 12.28. a. Describe the behavior of each. b. Compare these with the branch prediction state diagram in Section 12.4. Discuss the relative merits of each of the...
-
If z=sin.xy show that 1/y dz/dx = 1/x dz/dy
-
The following paragraph applies to Questions 7 and 8: wwwwwww Topone Ltd. wants to borrow $1,000,000 floating for 5 years; Lucky Ltd wants to borrow $1,000,000 fixed for 5 years. Their external...
-
3. Assets A and B are perfectly negatively correlated and have expected returns and standard deviations as follows: Asset A B Expected Return 10 Standard Deviation 8 16 11 What would be the min. you...
-
Growth and Financing Mr. Miyagi is very excited because sales for his nursery and plant company are expected to double from $600,000 to $1,200,000 next year. Mr. Miyagi notes that net assets (Assets...
-
A homeowner is using a personal loan to borrow $18,000 to replace the roof. The loan offers the option of making no payments for the first 12 months, during which the interest is compounded monthly...
-
Hedging with Forwards and Options: One year from today, you will be receiving CHF 500,000, but you would prefer dollars. The current spot rate is CHF 0.92 per USD, and the one year forward rate is...
-
LEARNING ACTIVITIES Concept Mapping: Creatively draw a paradigm that maps the concepts on: 1.Company Budgeting 2.Preparation of the master budget V.ASSESSMENT Show all computations in good form. 1....
-
What is the order p of a B + -tree? Describe the structure of both internal and leaf nodes of a B + -tree.
-
Distinguish between a direct and an indirect acquisition.
-
What is the acquisition date?
-
Distinguish between a business combination and a non-business acquisition.
Study smarter with the SolutionInn App