Kendrick Anderson Furniture Maker, LLC creates custom tables in Atlanta. Assume that the following represents monthly...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Kendrick Anderson Furniture Maker, LLC creates custom tables in Atlanta. Assume that the following represents monthly information on production volume and manufacturing costs since the company started operations Total Manufacturing Costs Total Tables Produced Living Room Tables Produced Dining Room Tables Produced June Year 1 $71,000 57,500 ..... ..... 110 25 85 July. August September October.. November.. December. January Year 2.. February. March 90 130 .... 45 ..... 45 79,724 15 115 64,250 95 36 59 57,300 60,900 62,700 70,130 68,400 57,400 76 24 52 92 48 44 105 110 24 50 81 60 102 .... 20 82 81 25 56 April May. 105,790 74,750 74,290 66,500 142 102 22 40 103 ... 125 June 115 15 18 100 July August September October. 106 88 49,888 72,668 71,700 74,200 54,900 85 28 55 81 30 57 61 116 120 39 November.. 120 90 December. 72 18 54 Required a. Use the high-low method to develop a cost-estimating equation for total manufacturing costs. Interpret the meaning of the "fixed" costs and comment on the results. b. Use the chart feature of a spreadsheet to develop a scatter graph of total manufacturing costs and total units produced. Use the graph to identify any unusual observations. c. Excluding any unusual observations, use the high-low method to develop a cost-estimating equation for total manufacturing costs. Comment on the results, comparing them with the results in requirement (a). d. Use simple regression analysis to develop a cost-estimating equation for total manufacturing costs. What advantages does simple regression analysis have in comparison with the high-low method of cost estimation? Why must analysts carefully evaluate the data used in simple regression analysis? e. A customer has offered to purchase 50 dining room tables for $452 per table. Management has asked your advice regarding the desirability of accepting the offer. What advice do you have for management? Additional analysis is required. Kendrick Anderson Furniture Maker, LLC creates custom tables in Atlanta. Assume that the following represents monthly information on production volume and manufacturing costs since the company started operations Total Manufacturing Costs Total Tables Produced Living Room Tables Produced Dining Room Tables Produced June Year 1 $71,000 57,500 ..... ..... 110 25 85 July. August September October.. November.. December. January Year 2.. February. March 90 130 .... 45 ..... 45 79,724 15 115 64,250 95 36 59 57,300 60,900 62,700 70,130 68,400 57,400 76 24 52 92 48 44 105 110 24 50 81 60 102 .... 20 82 81 25 56 April May. 105,790 74,750 74,290 66,500 142 102 22 40 103 ... 125 June 115 15 18 100 July August September October. 106 88 49,888 72,668 71,700 74,200 54,900 85 28 55 81 30 57 61 116 120 39 November.. 120 90 December. 72 18 54 Required a. Use the high-low method to develop a cost-estimating equation for total manufacturing costs. Interpret the meaning of the "fixed" costs and comment on the results. b. Use the chart feature of a spreadsheet to develop a scatter graph of total manufacturing costs and total units produced. Use the graph to identify any unusual observations. c. Excluding any unusual observations, use the high-low method to develop a cost-estimating equation for total manufacturing costs. Comment on the results, comparing them with the results in requirement (a). d. Use simple regression analysis to develop a cost-estimating equation for total manufacturing costs. What advantages does simple regression analysis have in comparison with the high-low method of cost estimation? Why must analysts carefully evaluate the data used in simple regression analysis? e. A customer has offered to purchase 50 dining room tables for $452 per table. Management has asked your advice regarding the desirability of accepting the offer. What advice do you have for management? Additional analysis is required.
Expert Answer:
Answer rating: 100% (QA)
Piedmont Table MA1435 Cost Estimation Interpretation and Analysis Requires Computer Spreadsheet LO2 3 Piedmont Table Company produces two styles of tables dining room and kitchen Presented is monthly ... View the full answer
Related Book For
Posted Date:
Students also viewed these general management questions
-
What advantages does using regression analysis have over the visual-fit method for determining cost functions?
-
What advantages does a softcopy plotter have over an analytical plotter?
-
What advantages does a retail chain have over a retailer who operates with a single store? Does a small retailer have any advantages in competing against a chain? Explain your answer.
-
TRUE OR FALSE. 6 POINTS EACH. (Always assume "Other things equal.") 1. In economics in the short run, a firm will have both fixed and variable resources. 2. In economics, the short run is defined as...
-
An analysis of the transactions made by Arthur Cooper & Co., a certified public accounting firm, for the month of August is shown below. The expenses were $650 for rent, $4,800 for salaries and...
-
Lento Inc. owned machinery with a $30,000 initial cost basis. Accumulated book depreciation with respect to the machinery was $12,000, and accumulated tax depreciation was $19,100. Lento sold the...
-
On December 31, 2018, Edmand, Inc., issued \(\$ 750,000\) of 11 percent, five-year bonds for \(\$ 722,400\), yielding an effective interest rate of 12 percent. Semiannual interest is payable on June...
-
On the basis of the following data, determine the value of the inventory at the lower of cost or market. Assemble the data in the form illustrated in Exhibit9. Unit Cost Price Unit Market Price...
-
An endowment fund is set up with a donation of $100,000. If it earns 6.2% compounded monthly, for how long will it sustain end-of- month withdrawals of $1,080? (Include the final smaller withdrawal.)...
-
Trace or copy the graph of the given function f. (Assume that the axes have equal scales.) Then use the method of Example 1 to sketch the graph of f' below it. (a) (b) (c) yA
-
A product based on a new technology has two major potential markets. The dominant uncertainty associated with it has to do with the technology rather than markets. Accordingly, the product will...
-
A bond with a par value of $ 1 , 0 0 0 , 0 0 0 was issued at 9 8 on January 1 , 2 0 2 4 . The coupon interest rate is 6 % and interest payments are made semi - annually. The bond has a two - year...
-
Utilize the Business-Model-Canvas-jpeg to help formulate your ideas. Use bullet points (no prose).Each group should submit one BMC. A start-up hasinventeda productwhich isabiodegradablesingle-use...
-
Prepare a schedule assigning each activity's overhead cost to the two products. Assignment of overhead: BC113 Machine set-up Machining Packing $ AD908 25 $ $ 1004 +A $ 15 4016 $ 150 $ 350 Overhead...
-
Frank and Frances decide to form a partnership, F & F Partners, as equal partners. Frank contributes $ 1 0 0 , 0 0 0 cash and $ 2 0 , 0 0 0 of equipment ( equipment has a $ 5 , 0 0 0 basis ) ....
-
Based on the crystal structure, calculate the theoretical density of sodium chloride. Compare the value obtained with the measured density 2.16 g/cm. we give the ionic rays of sodium (0.102 nm) and...
-
Five months into their Early Bird pilot, Starbucks found that average arrival rate at the store had plateaued at 1 customer/1.5 minutes. Concerned about the lack of future growth Starbucks...
-
The following cost information was provided to you for analysis: September 12,000 Units Produced Costs: TIC TAC TOE TING August 10,000 P80,000 70.000 60.000 50,000 How much is the fixed cost per...
-
Why do you think the depreciation of the Asian currencies adversely affected U.S. firms? (There are at least three reasons, each related to a different type of exposure of some U.S. firms to exchange...
-
Describe the possible errors involved in assessing country risk. In other words, explain why country risk analysis is not always accurate.
-
Alaska, Inc., would like to acquire Estoya Corp., which is located in Peru. In initial negotiations, Estoya has asked for a purchase price of 1 billion Peruvian new sol. If Alaska completes the...
-
Show that, for the squared-error loss, the approximation error \(\ell\left(g^{\mathscr{C}} ight)-\ell\left(g^{*} ight)\) in (2.16), \(\begin{array}{llllll}\text { is } \quad \text { equal } & \text {...
-
Let \(\widehat{\boldsymbol{\beta}}=\boldsymbol{A}^{+} \boldsymbol{y}\). Using the defining properties of the pseudo-inverse, show that for any \(\boldsymbol{\beta}\) \(\in \mathbb{R}^{p}\) \[...
-
Let \(\mathbf{X}\) be an \(n\)-dimensional normal random vector with mean vector \(\boldsymbol{\mu}\) and covariance matrix \(\boldsymbol{\Sigma}\), where the determinant of \(\boldsymbol{\Sigma}\)...
Study smarter with the SolutionInn App