Using Regression Results to Construct and Apply a Cost Formula Dohini Manufacturing Company had the following...

Using Regression Results to Construct and Apply a Cost Formula Dohini Manufacturing Company had the following 12 months of data on purchasing cost and number of purchase orders. Month Purchasing Cost Number of Purchase Orders January $18,860 370 February 18,065 330 March 19,250 370 April 18,050 410 May 19,345 400 June 19,500 450 July 19,670 460 August 20,940 560 September 19,430 440 October 20,020 500 November 18,800 470 December 19,340 480 The controller for Dohini Manufacturing ran regression on the data, and the coefficients shown by the regression program are: Intercept 15,021 (rounded to the nearest dollar) X variable 1 9.74 (rounded to the nearest cent) Required: 1. Construct the cost formula for the purchasing activity showing the fixed cost and the variable rate. Total purchasing cost = $ 15,021 + ($ 9.74 × Purchase orders) 2. If Dohini Manufacturing Company estimates that next month will have 430 purchase orders, what is the total estimated purchasing cost for that month? (Round your answer to the nearest dollar.) $ 19,209 3. What if Dohini Manufacturing wants to estimate purchasing cost for the coming year and expects 5,340 purchase orders? What will estimated total purchasing cost be? (Round your answer to the nearest dollar.) $ What is the total fixed purchasing cost?

Expert Solution

ekkarill92 answered 2 years ago

Using Multiple Regression Results to Construct and Apply a Cost Formula The controller for Dohini Manufacturing...

Using Multiple Regression Results to Construct and Apply a Cost Formula The controller for Dohini Manufacturing Company felt that the number of purchase orders alone did not explain the monthly purchasing cost. He knew that nonstandard orders (for example, one requiring an overseas supplier) took more time and effort. He collected data on the number of nonstandard orders for the past 12 months and added that information to the data on purchasing cost and total number of purchase orders. Month ...

Using Regression to Calculate Fixed Cost, Calculate the VariableRate, Construct a Cost Formula, and Determine...

Using Regression to Calculate Fixed Cost, Calculate the Variable Rate, Construct a Cost Formula, and Determine Budgeted CostPizza Vesuvio makes specialty pizzas. Data for the past 8 months were collected:MonthLabor CostEmployee HoursJanuary$7,200360February8,140550March9,899630April9,787590May8,490480June7,450350July9,490570August7,531310Coefficients shown by a regression program for Pizza Vesuvio's data are:Intercept4,613X Variable8.09In your calculations, round the variable rate per employee hour to the nearest cent.Required:Use the results of regression to make the following calculations:1. Calculate the fixed cost of labor.$Calculate the variable rate per employee hour.$per employee hour2. Construct...

Using the Excel file Weddings, apply the Regression tool using the wedding cost as the dependent...

Using the Excel file Weddings, apply the Regression tool using the wedding cost as the dependent variable and attendance as the independent variable. What is the regression model? Interpret all key regression results, hypothesis tests, and confidence intervals in the output. If a couple is planning a wedding for 175 guests, how much should they budget? Couple's Income Bride's age Payor Wedding cost Attendance Value Rating $130,000 22 Bride's Parents $60,700.00 300 3 $157,000 23 Bride's Parents $52,000.00 350 1...

Precision Manufacturing had the following operating results for 2014: sales = $36,942; cost of goods sold...

Precision Manufacturing had the following operating results for 2014: sales = $36,942; cost of goods sold = $24,600; depreciation expense = $1,700; interest expense = $1,400; dividends paid = $1,000. At the beginning of the year, net fixed assets were $14,300, current assets were $8,700, and current liabilities were $6,600. At the end of the year, net fixed assets were $13,900, current assets were $9,200, and current liabilities were $7,400. The tax rate for 2014 was 34 percent. What is...

Titan Football Manufacturing had the following operating results for 2014: sales = $19,950; cost of goods...

Titan Football Manufacturing had the following operating results for 2014: sales = $19,950; cost of goods sold = $13,810; depreciation expense = $2,200; interest expense = $260; dividends paid = $720. At the beginning of the year, net fixed assets were $22,300, current assets were $3,110, and current liabilities were $1,900. At the end of the year, net fixed assets were $26,540, current assets were $3,620, and current liabilities were $1,990. The tax rate for 2014 was 40 percent. (Enter...

Titan Football Manufacturing had the following operating results for 2016: sales = $19,850; cost of goods...

Titan Football Manufacturing had the following operating results for 2016: sales = $19,850; cost of goods sold = $13,910; depreciation expense = $2,300; interest expense = $310; dividends paid = $620. At the beginning of the year, net fixed assets were $17,300, current assets were $3,010, and current liabilities were $2,000. At the end of the year, net fixed assets were $20,540, current assets were $3,420, and current liabilities were $2,090. The tax rate for 2016 was 30 percent. a....

Titan Football Manufacturing had the following operating results for 2016: sales = $19,930; cost of goods...

Titan Football Manufacturing had the following operating results for 2016: sales = $19,930; cost of goods sold = $13,830; depreciation expense = $2,220; interest expense = $270; dividends paid = $700. At the beginning of the year, net fixed assets were $21,300, current assets were $3,090, and current liabilities were $1,920. At the end of the year, net fixed assets were $25,340, current assets were $3,580, and current liabilities were $2,010. The tax rate for 2016 was 30 percent. a....

Titan Football Manufacturing had the following operating results for 2016: sales = $19,920; cost of goods...

Titan Football Manufacturing had the following operating results for 2016: sales = $19,920; cost of goods sold = $13,840; depreciation expense = $2,230; interest expense = $275; dividends paid = $690. At the beginning of the year, net fixed assets were $20,800, current assets were $3,080, and current liabilities were $1,930. At the end of the year, net fixed assets were $24,740, current assets were $3,560, and current liabilities were $2,020. The tax rate for 2016 was 40 percent. a....

Robison Manufacturing had the following operating results for 2017: sales = $40,000; cost of goods sold...

Robison Manufacturing had the following operating results for 2017: sales = $40,000; cost of goods sold = $25,000; depreciation expense = $3,200; interest expense = $500; dividends paid = $800. At the beginning of the year, net fixed assets were $22,000, current assets were $3,400, and current liabilities were $2,800. At the end of the year, net fixed assets were $28,000, current assets were $4,200, and current liabilities were $2,100. The tax rate for 2017 was 40 percent. What is...

Prescott Football Manufacturing had the following operating results for 2019: sales = $30,174; cost of goods...

Prescott Football Manufacturing had the following operating results for 2019: sales = $30,174; cost of goods sold = $21,740; depreciation expense = $3,512; interest expense = $544; dividends paid = $849. At the beginning of the year, net fixed assets were $20,046, current assets were $3,029, and current liabilities were $3,776. At the end of the year, net fixed assets were $23,077, current assets were $4,447, and current liabilities were $3,077. The tax rate for 2019 was 21 percent. a....

Question