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...
-
How is a data warehouse different from a database? How are they similar?
-
Potholes on a highway can be a serious problem and are in constant need of repair. With a particular type of terrain and make of concrete, past experience suggests that there are, on the average, 2...
-
A 72-kg woman is walking at \(1.5 \mathrm{~m} / \mathrm{s}\). An \(8-\mathrm{kg}\) dog is running at six times that speed in the same direction. At what speed and in what direction relative to the...
-
The Best Wheels Bicycle Company produces bicycles in different styles for boys and girls, in heights of 26 inches or 20 inches, and with 10 speeds, 3 speeds, or 1 speed. a. How many different kinds...
-
"Managing Away Bad Habits Team Assignment Organizational Behavior IILeadership Assigned is ashort case from the exercise Managing Away Bad Habits. The task is to develop a turnaround strategy for...
-
On December 31, Y3, Aylmer Industries Inc. purchased 85% of the outstanding shares of Belmont Inc. The purchase price is indicated on the excel file. The entry has been recorded on the books of...
-
EYESRUS are unable to meet their daily expenditure and their creditors are no longer willing to provide them with credit facilities. You have been asked to give your professional analysis on the...
-
The invasion of Israel by Hamas A. Using the Autocratic Leadership Style, thoroughly analyze an ethical decision facing this situation B. What conclusions can be made from the analysis? Thoroughly...
-
The financial information in the Excel file associated with this exercise was obtained from Form 10-K reports for Costco Wholesale Corporation . In this exercise, we examine how changing the starting...
-
Complete all questions 1. Refer to the "Caterpillar" file in Moodle and answer the following. a. Calculate the Addition Funds Needed for Working Capital for Caterpillar for the calendar year 2016. b....
-
1. Prepare journal entries to record the following transactions for Sherman Systems. a. Purchased 6,900 shares of its own common stock at $44 per share on October 11. b. Sold 1,475 treasury shares on...
-
Pick any two leadership styles that interests you out of the following leadership styles: Autocratic Leadership Bureaucratic Leadership Democratic Leadership Laissez-faire Leadership ...
-
D 1 2 3 4 5 5 7 Address: Company Information Employer Identification Number (EIN): Date Incorporated: 1234 Anywhere Blvd, Sun City, AZ 85351 85-1234566 1/2/2022 Notes: 1. Meals are subject to 50%...
-
A firm has the following balance sheet: Assets Cash Accounts receivable Inventory Plant and equipment $ 15,000 150,000 92,000 170,000 $427,000 Liabilities and Equity Accounts payable Long-term debt...
-
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...
-
What is antisense RNA? How does it affect the translation of a complementary mRNA?
-
W hat is diauxic growth? Explain the roles of cAMP and CAP in this process.
-
List and describe three general ways that the functions of transcription factors can be modulated.
Study smarter with the SolutionInn App