Prest Metal Products manufactures and sells various products. The products are manufactured at one of a...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Prest Metal Products manufactures and sells various products. The products are manufactured at one of a few plants (depending on the product) and then shipped to a distribution center for eventual delivery to customers. The Auburn Distribution Center (ADC) of Prest Metal Products handles a subset of Prest Products. The products handled by the ADC are fairly similar in size and weight and differ primarily in features that do not affect handling or packaging. When the sales staff at Prest receives an order, they send it to the appropriate distribution center to fill (collect units and package for shipping) and ship the units to the customer. A single order may consist of one (although unusual) or more units. Regardless of the number of units in the order, ADC has to follow certain steps to process the order, such as verifying the customer's address and credit information, review the order for errors, and so on. The ADC is also responsible for following up on any complaints from the customer about problems with the order. The ADC expects to distribute 250,000 units of products next month. As a part of the normal planning process at ADC, the center controller has classified next month's expected operating costs (excluding costs of the distributed product) as fixed or variable (with respect to units shipped) as follows. Administration Center labor Center lease Account Depreciation on equipment Miscellaneous Order processing Supervision Supplies (including packing materials) Utilites Total Operating Costs $ 37,400 297,400 127,800 125,000 127,400 178,800 76,300 201, 300 86,000 $ 1,257,400 Behavior $ 34,800 Fixed $144,300 Fixed $ 102,800 Fixed $ 114,800 Fixed $56,800 Fixed $ 40,800 Fixed $ 52,800 Fixed All Variable $ 62,800 Fixed The center manager has asked the financial staff for more information about center costs and whether there is a better way to estimate them rather than having the controller go through the monthly account analysis. The center manager assigned the controller's staff to recommend improvements to the current process. Historically, all the financial and operation performance measures at ADC have been based on the number of units shipped. However, in preparing the analysis, one of the analysts on the controller's staff collected information from the last twelve months on orders processed as well units shipped and ADC operating costs. These follow here: Month 1 2 3 4 5 6 7 8 9 10 11 12 Units 239,970 247,250 244,550 259,410 255,360 269,540 250,630 281,020 Orders Center Cost 10,390 $ 997,030 16,440 1,224,870 1,064,800 13,170 15,350 16,910 13,570 16,170 12,820 8,850 12, 230 1,205, 240 1, 222, 120 1,221,730 1,157,460 271,560 287,100 284,400 294,570 The controller and other managers at ADC agree that operations and costs last year were representative for the center. 13,240 11,430 1,216,590 1,136,790 1,164, 150 1,183,070 1,217,614 d-1. Using Excel, calculate a multiple regression of operating costs on units shipped and orders processed, and enter the regression coefficients. d-2. Compute an estimation of operating costs assuming that 275,000 units based on 13,000 orders will be shipped in a future month by using the results of a multiple regression of operating costs on units shipped and orders processed. Req D1 Req D2 Using Excel, calculate a multiple regression of operating costs on units shipped and orders processed, and enter the regression coefficients. Note: Round "Intercept" to the nearest whole dollar amount. Round "Units" and "Orders processed" to 2 decimal places. Intercept Units Orders processed Req D1 Req D2 Compute an estimation of operating costs assuming that 275,000 units based on 13,000 orders will be shipped in a future month by using the results of a multiple regression of operating costs on units shipped and orders processed. Note: Round "Units" and "Orders processed" to 2 decimal places. Round "Intercept" and final answer to the nearest whole dollar amount. Estimate of operating costs < Req D1 Req D2 > Show less Prest Metal Products manufactures and sells various products. The products are manufactured at one of a few plants (depending on the product) and then shipped to a distribution center for eventual delivery to customers. The Auburn Distribution Center (ADC) of Prest Metal Products handles a subset of Prest Products. The products handled by the ADC are fairly similar in size and weight and differ primarily in features that do not affect handling or packaging. When the sales staff at Prest receives an order, they send it to the appropriate distribution center to fill (collect units and package for shipping) and ship the units to the customer. A single order may consist of one (although unusual) or more units. Regardless of the number of units in the order, ADC has to follow certain steps to process the order, such as verifying the customer's address and credit information, review the order for errors, and so on. The ADC is also responsible for following up on any complaints from the customer about problems with the order. The ADC expects to distribute 250,000 units of products next month. As a part of the normal planning process at ADC, the center controller has classified next month's expected operating costs (excluding costs of the distributed product) as fixed or variable (with respect to units shipped) as follows. Administration Center labor Center lease Account Depreciation on equipment Miscellaneous Order processing Supervision Supplies (including packing materials) Utilites Total Operating Costs $ 37,400 297,400 127,800 125,000 127,400 178,800 76,300 201, 300 86,000 $ 1,257,400 Behavior $ 34,800 Fixed $144,300 Fixed $ 102,800 Fixed $ 114,800 Fixed $56,800 Fixed $ 40,800 Fixed $ 52,800 Fixed All Variable $ 62,800 Fixed The center manager has asked the financial staff for more information about center costs and whether there is a better way to estimate them rather than having the controller go through the monthly account analysis. The center manager assigned the controller's staff to recommend improvements to the current process. Historically, all the financial and operation performance measures at ADC have been based on the number of units shipped. However, in preparing the analysis, one of the analysts on the controller's staff collected information from the last twelve months on orders processed as well units shipped and ADC operating costs. These follow here: Month 1 2 3 4 5 6 7 8 9 10 11 12 Units 239,970 247,250 244,550 259,410 255,360 269,540 250,630 281,020 Orders Center Cost 10,390 $ 997,030 16,440 1,224,870 1,064,800 13,170 15,350 16,910 13,570 16,170 12,820 8,850 12, 230 1,205, 240 1, 222, 120 1,221,730 1,157,460 271,560 287,100 284,400 294,570 The controller and other managers at ADC agree that operations and costs last year were representative for the center. 13,240 11,430 1,216,590 1,136,790 1,164, 150 1,183,070 1,217,614 d-1. Using Excel, calculate a multiple regression of operating costs on units shipped and orders processed, and enter the regression coefficients. d-2. Compute an estimation of operating costs assuming that 275,000 units based on 13,000 orders will be shipped in a future month by using the results of a multiple regression of operating costs on units shipped and orders processed. Req D1 Req D2 Using Excel, calculate a multiple regression of operating costs on units shipped and orders processed, and enter the regression coefficients. Note: Round "Intercept" to the nearest whole dollar amount. Round "Units" and "Orders processed" to 2 decimal places. Intercept Units Orders processed Req D1 Req D2 Compute an estimation of operating costs assuming that 275,000 units based on 13,000 orders will be shipped in a future month by using the results of a multiple regression of operating costs on units shipped and orders processed. Note: Round "Units" and "Orders processed" to 2 decimal places. Round "Intercept" and final answer to the nearest whole dollar amount. Estimate of operating costs < Req D1 Req D2 > Show less
Expert Answer:
Answer rating: 100% (QA)
To calculate the multiple regression of operating costs on units shipped and orders processed we can use Excel Here are the steps 1 Arrange the data in separate columns in Excel The Units column shoul... View the full answer
Related Book For
Accounting for Decision Making and Control
ISBN: 978-1259564550
9th edition
Authors: Jerold Zimmerman
Posted Date:
Students also viewed these accounting questions
-
Solve the formula -x+6y= 9 for y when x = 3. Provide your answer below:
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Use the following information for Questions 1 a) and 1 b): a) At the beginning of the year, Juju Sdn. Bhd. estimated the following: Polishing Department Overhead Direct labour hours Kiln hours Firing...
-
A 9.3-kg child sits in a 3.7-kg high chair. (a) Draw a free-body diagram for the child, and find the normal force exerted by the chair on the child. (b) Draw a free-body diagram for the chair, and...
-
Prove that \[ \left\langle q\left|e^{-\beta \hat{H}}ight| q^{\prime}ightangle=\exp \left[-\beta \hat{H}\left(-i \hbar \frac{\partial}{\partial q}, qight)ight] \delta\left(q-q^{\prime}ight) \] where...
-
Rewrite the solution to Problem 3 and identify the initial value Green's functions. Data from Problem 3 Find product solutions, \(u(x, t)=b(t) \phi(x)\), to the wave equation satisfying the boundary...
-
Steinborn Homes manufactures prefabricated chalets in Colorado. The company uses a perpetual inventory system and a job cost system in which each chalet is a job. The following events occurred during...
-
Suppose that risk-free zero interest rates withsemiannual compounding are as follows:Maturity (years)Rates (semiannual compounding)Rates (continuou 2 answers
-
It took a long time but the Securities and Exchange Commission finally acted and held auditors responsible for the fraud that occurred in banks during the financial recession. Surprisingly to some,...
-
On the grid draw the graph of a function m(x) with the following properties: (a) the domain of m(a) is (-3, 4), (b) m(x) has exactly two stationary points, (c) m(x) has exactly one singular point,...
-
Adams Manufacturing Company makes tents that it sells directly to camping enthusiasts through a mail-order marketing program. The company pays a quality control expert $75,400 per year to inspect...
-
A. Explain what strategic cost management is. B. Enumerate the four doables we should be able to address. COST ANALYSIS COST DETERMINATION, COST CONTROL COST FOR DECISION MAKING. C. Explain the use...
-
dy (e) Find dx if y = x+2x. (f) Evaluate the limit Itx-24 (g) Find the dy/dx of y=A.sin(x)+ BCos(x). (h) Define the continuity of a function.
-
Jaguar Plastics Company has been operating for three years. At December 31 of last year, the accounting records reflected the following: Cash Investments (short-term) Accounts receivable Inventory...
-
What Is a Personal Marketing Plan? Your ability to use the principles of this course and textbook to market yourself will be critical to your success after you leave college. By creating your...
-
Adams County Area on Aging is a nonprofit organization that helps its senior residents live in their own homes by providing three essential services. These services are home health care, meal...
-
Open Text Corporation provides a suite of business information software products. Exhibit 10-9 contains Note 10 from the companys 2013 annual report detailing long-term debt. Required: a. Open Text...
-
Durnstein Schnapps produces three types of schnapps from locally grown Austrian pears, plums, and cherries. Schnapps is a clear, colorless beverage distilled from fermented fruit that normally...
-
Stahl produces and sells a single product and faces an inelastic demand curve, meaning it can sell as many units as it wants without affecting the selling price. Stahl has a cost structure consisting...
-
Dewan Locks produces and sells a keyless bicycle lock that uses a small wireless fob to lock and unlock the lock without the need of a key. Dewan produces two models: one for the European market (EU)...
-
Sketch (by hand) the graphs of each of the following functions over four periods. Then sketch the extensions of each of the functions as both an even and odd periodic function. Determine the...
-
Consider the function \(f(x)=x,-\pi
-
Differentiate the Fourier sine series term by term in Problem 18. Show that the result is not true. Why not? Data from Problem 18 Consider the function \(f(x)=x, 0
Study smarter with the SolutionInn App