The management team at Waterway Corporation is capitalizing on the trend for live-edge cedar fireplace mantels-beautiful,...
Fantastic news! We've Found the answer you've been seeking!
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/6649605cc8a9b_8286649605c43ead.jpg)
Transcribed Image Text:
The management team at Waterway Corporation is capitalizing on the trend for live-edge cedar fireplace mantels-beautiful, simple, organic. In fact, sales are so strong they are running out of inventory. This means that budgeting for next year will be extremely important, to ensure sure that Waterway can source enough cedar. With budgeted sales as the starting point for the entire process, the management team agrees that the following levels present the most likely scenario for the first five months of the upcoming year. January February March April May Budgeted number of mantels to be sold 390 440 420 420 440 In addition to sales volume, many other specifics are required in order to complete the company's operating budgets. Key details associated with prices, costs, and usage are as follows. Budgeted selling price is $500 per mantel. Each mantel measures 3 inches x 12 inches 4 feet. Target ending inventory of finished mantels is 20% of next month's budgeted sales. However, beginning inventory on January 1 is expected to be only 39 units. Waterway' primary DM, rough-cut cedar, is purchased from the supplier already at the desired height and depth (3 inches high, 12 inches deep). Waterway cuts the cedar planks to the desired 4-foot lengths. Each rough-cut board costs Waterway $50 per foot. Target ending DM inventory (rough-cut cedar) is 50% of next month's production needs. DL to sand, stain, and treat the rough-cut cedar costs $20 per hour. Each mantel requires one hour of labor time. MOH resources include variable costs budgeted to be $10/board foot, plus budgeted monthly Fixed MOH costs of $4,100. Depreciation of $1,800 is included in that monthly fixed cost. SG&A costs are also broken down into their variable and fixed components: budgeted variable SG&A costs are $50/unit sold, while budgeted fixed monthly SG&A costs are $61,000, which includes $7,500 of depreciation. All sales are made on account, with 25% paying in the month of sale and 70% paying in the month following the sale. The remainder is considered uncollectible. December sales in the prior year were budgeted to be $233,000. Beginning finished goods inventory was held at a cost of $270/unit from the prior year. The management team at Waterway Corporation is capitalizing on the trend for live-edge cedar fireplace mantels-beautiful, simple, organic. In fact, sales are so strong they are running out of inventory. This means that budgeting for next year will be extremely important, to ensure sure that Waterway can source enough cedar. With budgeted sales as the starting point for the entire process, the management team agrees that the following levels present the most likely scenario for the first five months of the upcoming year. January February March April May Budgeted number of mantels to be sold 390 440 420 420 440 In addition to sales volume, many other specifics are required in order to complete the company's operating budgets. Key details associated with prices, costs, and usage are as follows. Budgeted selling price is $500 per mantel. Each mantel measures 3 inches x 12 inches 4 feet. Target ending inventory of finished mantels is 20% of next month's budgeted sales. However, beginning inventory on January 1 is expected to be only 39 units. Waterway' primary DM, rough-cut cedar, is purchased from the supplier already at the desired height and depth (3 inches high, 12 inches deep). Waterway cuts the cedar planks to the desired 4-foot lengths. Each rough-cut board costs Waterway $50 per foot. Target ending DM inventory (rough-cut cedar) is 50% of next month's production needs. DL to sand, stain, and treat the rough-cut cedar costs $20 per hour. Each mantel requires one hour of labor time. MOH resources include variable costs budgeted to be $10/board foot, plus budgeted monthly Fixed MOH costs of $4,100. Depreciation of $1,800 is included in that monthly fixed cost. SG&A costs are also broken down into their variable and fixed components: budgeted variable SG&A costs are $50/unit sold, while budgeted fixed monthly SG&A costs are $61,000, which includes $7,500 of depreciation. All sales are made on account, with 25% paying in the month of sale and 70% paying in the month following the sale. The remainder is considered uncollectible. December sales in the prior year were budgeted to be $233,000. Beginning finished goods inventory was held at a cost of $270/unit from the prior year.
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
Villaverde Company insures the life of its president for P8,000,000, the corporation being the beneficiary of an ordinary life policy. The premium is P200,000. The policy is dated January 1, 2010....
-
Write a program to merge two sorted files into a single file using Linux/UNIX.
-
Ambassador Watch Company budgeted the following costs for anticipated production for April 2002: Prepare a factory overhead cost budget, separating variable and fixed costs. Assume that all indirect...
-
Compute direct materials price variances (Learning Objective 4) Refer to the McDonalds Data Set on page 643. Actual prices paid for ingredients purchased during the week were: 1. Compute the direct...
-
Read the article Security Controls that Work by Dwayne Melancon in the 2007 Issue, Volume 4 of the Information Systems Control Journal (available www.isaca.org/Journal/Past-Issues/2007/Volume-4...
-
0 Question 12 v Use linear approximation to estimate the amount of paint in cubic centimeters needed to apply a coat of paint 0.08 cm thick to a hemispherical dome with a diameter of 40 meters. ' '...
-
Do you see certain groups favoring certain product characteristics give 3 scenarios
-
Can you check if all the methods have the intended complexities and if they don't change them so that they do. Intended Complexities Let N be the length of islands in initialisation. __init__ should...
-
Silver Titan's company has projected sales for the first seven months of 2021 are given below: Month January February March April May June July Amount $250,000 $340,000 $280,000 $300,000 $350,000...
-
The quality of Martian Motor Co. vehicles has increased dramatically. Their cars now sit at the top of the list in vehicle quality, surpassing Toyota. To management's surprise, this has not led to an...
-
a) Make initial journal entries. b) Make entries that are adjusted for December 31, 2017. Action Quest Games adjusts its accounts annually. Assume that any prepaid expenses are initially recorded in...
-
A product costing $350, less 30%, 20%, and 10%, sells to allow for overhead expenses of 30% of the selling price and profit of 20% of the selling price. During a sale, the product is marked down by...
-
Yield to maturity The Salem Company bond currently sells for $955, has a 12% coupon interest rate and a $1,000 par value, pays interest annually, and has 15 years to maturity. a. Calculate the yield...
-
An environmentalist wants to determine if the median amount of potassium (mg/L) in rainwater in Lincoln County, Nebraska, is different from that in the rainwater in Clarendon County, South Carolina....
-
The Acorn Nursery School Corporation provides baby-sitting and childcare programs. On January 31, 20xx, the company had the following trial balance: During the month of February, the company...
-
Graph \(A\). \(b ightarrow c ightarrow f ightarrow e ightarrow d ightarrow b ightarrow e\) Use the figure shown to determine whether the sequence of vertices in the given graph is a Hamilton path, an...
-
Graph A. \(e ightarrow b ightarrow c ightarrow f ightarrow e ightarrow b ightarrow e\) Use the figure shown to determine whether the sequence of vertices in the given graph is a Hamilton path, an...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App