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...
-
If your uncle borrows $60,000 from the bank at 10 percent interest over the seven-year life of the loan, what equal annual payments must be made to discharge the loan, plus pay the bank its required...
-
A white college receptionist is fired when it is found that she told a black college applicant that the applications for admissions are distinguished by race by the notation of a small RH in the...
-
Information from a run ticket shows that 1,000 net barrels of oil with an API gravity of 36 were sold. The selling price is based on a contract price of $66/bbl, adjusted downward 4 for each degree...
-
Determine the number of salespeople FireSpot needs if it has 1,000 retail customer accounts that need to be called on five times per year. Each sales call lasts approximately 2.5 hours, and each...
-
Affordable Electronics Inc. manufactures medium-quality, reasonably priced wireless speakers for home use. The company uses standards to control its costs. The labour standards that have been set for...
-
Show that if G is a CFG in Chomsky normal form, then for any string w L(G) of length n 1, exactly 2n 1 steps are required for any derivation of w.
-
On April 1, Anita Strods created a new travel agency, Strods Travel. The following transactions occurred during the company's first month. April 2 Strods invested $46,000 cash and computer equipment...
-
Chowfew Pty Ltd (Chowfew) is a resident Australian company that commenced business on 1 July 2022 and sells music equipment to retail customers. For the income year ended 30 June 2023, Chowfew's...
-
Oliver Company purchases inventory costing $34 on September 14. The company spends $5 to transfer the inventory to its store and an additional $8 to set it up. One of Oliver's employees accidentally...
-
A . The manager of a small printing business receives an enquiry from a customer about printing 30,000 leaflets. The customer is willing to pay 25,000. Currently there is no spare capacity in terms...
-
what ways do hormones influence gene expression through epigenetic mechanisms, and how might these effects contribute to developmental programming and disease susceptibility ?
-
Write out the IMC plan that Iron Man 3 planned. Look at how everything is tied together and discuss your thoughts and opinions on this campaign. Was it successful? Would you have done anything...
-
Identify the type of error in this sentence... They relaxed and buckled in for take-off. his why. very own co Fragment rn som Comma splice that cas No Error Run-on
-
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...
-
Transatlantic Arbitrage. A corporate treasury working out of Vienna with operations in New York simultaneously calls Citibank in New York City and Barclays in London. The banks give the following...
-
Venezuelan Bolivar (A). The Venezuelan government officially floated the Venezuelan bolivar (Bs) in February 2002. Within weeks, its value had moved from the pre-float fix of Bs778/$ to Bs1025/$. a....
-
Venezuelan Bolivar (B). The Venezuelan political and economic crisis deepened in late 2002 and early 2003. On January 1, 2003, the bolivar was trading at Bs1400/$. By February 1, its value had fallen...
Study smarter with the SolutionInn App