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...
-
In this section we discussed examples of ordinary, everyday functions: Population is a function of time, postage cost is a function of weight water temperature is a function of time. Give three other...
-
BASIC DATA: 1. Details of Contract 315, for Customer Alfa Ltd begun during the year: ITEM Materials purchased and delivered to site 596 00 Materials issues from store 4800 Materials returned to store...
-
A deep pool of water is initially at \(4^{\circ} \mathrm{C}\) and suddenly the surface is exposed to a freezing front at \(-4{ }^{\circ} \mathrm{C}\) and remains so exposed for a long time. Find the...
-
1. A patent increases the incentive to develop new products because it ________ the price of the product and thus generates profit to cover a firms costs of _______. 2. In some cases, a patent is...
-
Image transcription text Part 1 Investigate the effect different composite layups have on the response in a tensile test. To get startedr review the following video, which demonstrates how to design...
-
Auditor Changes at Daily Journal Corporation Charlie Munger is vice chairman of Berkshire Hathaway Inc. and is informally known as War- ren Buffett's "right arm." Munger also serves as chairman of...
-
Reconcile the given checking account. Compare the items appearing on the bank statement to the check register. Click the icon to view the items on the check register. Click the icon to view the items...
-
In a substantial number of criminal appeals, some state appellate courts routinely issue decisions merely stating Judgment Affirmed. When an appellate court rejects a defendants issues on appeal,...
-
Why does the law require more formal proceedings in cases of indirect contempt than in cases of direct criminal contempt?
-
What means of punishment for criminal offenses exist in your state? Is capital punishment available for persons convicted of first-degree murder? Which punishments, if any, do you think are most...
-
If you were CEO of a company, would you spend $15 million per year to put your companys name on a stadium?
-
After studying briefs submitted by counsel and hearing oral arguments in a proceeding open to the public, appellate judges retire to privately discuss and decide the merits of criminal appeals....
-
A hiker walks 15 km towards the north then 16 km towards the east then 15 km towards the north. How far away and in which direction is the hiker with reference to the starting point? Pick ONE option...
-
1) The government decided to reduce taxes on fast-food to increase revenue. The government assumes that fast-food products have a) An inelastic demand b) An elastic demand c) A demand curve that is...
-
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)...
-
Why is the bar chart not an adequate planning and scheduling tool?
-
Since the bar chart is ineffective as a planning and scheduling tool, why is it still widely used in the construction industry?
-
For the CPM Calculation Exercise found on the companion website, determine the ES, EF, LS, LF, FF, and TF for each activity. Identify the activities through which the critical path runs. How many...
Study smarter with the SolutionInn App