Your Perfect Assignment is Just a Click Away
We Write Custom Academic Papers

100% Original, Plagiarism Free, Customized to your instructions!

glass
pen
clip
papers
heaphones

DC Delco CorporationDC Delco Corporation manufactures and sells the various elec

DC Delco CorporationDC Delco Corporation manufactures and sells the various elec

DC Delco CorporationDC Delco Corporation manufactures and sells the various electrical parts. One of the bestsellingproducts is an electric motor. The company recently received a $750,000 order forvarious quantities of three types of electric motors: Model A, B, and C. More specifically, thefirm received the following number of orders for each of the three electric motors.Model A Model B Model CNumber Ordered 3,000 2,000 900Each electric motor requires a certain amount of time to wire and harness. Model A requires 2hours of wiring and 1 hour of harnessing per unit; Model B needs 1.5 hours of wiring and 2hours for harnessing per unit; and Model C requires 3 hours of wiring and 1 hour of harnessingper unit. Unfortunately, DC Delco does not have enough wiring and harnessing capacity tosatisfy the order by its due date. The firm currently has only 10,000 hours of wiring capacity and5,000 hours of harnessing capacity available to devote to this order. However, the company cansubcontract any portion of this order to one of its suppliers. The unit costs of producing eachmodel in-house and buying the finished products from the vendor are summarized below.Model A Model B Model CCost to Make $50 $83 $130Cost to Buy $61 $97 $145You have been hired by the CEO of DC Delco, James Strong, to determine the number of electricmotors to make and the number to buy to fill the customer order at the least possible cost.Directions: This case analysis can be done either individually or by a team with a maximum ofthree students. Prepare a three -page (maximum) business memo to James Strong, outliningyour analysis, explanation, and conclusion. Submit your business memo on April 17, 2015(Friday), 11 am. (No Exception). On the main body of your business memo, identify andexplain your decision variables to solve the problem. Using the decision variables, you arerequired to write down the mathematical equations representing this problem and to use ExcelSolver to solve the problem. Include and explain all of the mathematical equations on the mainbody, and also attach Excel Solver results at the end of your business memo as your supportingmaterials. Make sure to include your team members’ names and their roster numbers on thememo, too.Use the memo writing guidelines (sample business memo) from the course website as yourreference. Do not simply follow the guideline. Your business memo should be clear, in detail,professional, and self-explanatory. Along with your thorough analysis, a good organization andSpring 20152flow of paragraphs and sentences, clarity and correctness, and your writing are important in theevaluation.If the case analysis is done by a team, a team evaluation will be conducted after submitting thememo to reflect your contribution to the analysis.Checklists for Your Business Memo:(1) Do you have a maximum of three pages, including all of your supporting materials?(2) Did you identify and explain your decision variables on the main body of your memo?(3) Did you include and explain all of the mathematical equations on the main body?(4) Did you attach Excel Solver results, showing your total cost, at the end of your memo?(5) Did you complete a final editing before submitting your memo?THIS IS A TEMPLATE **************(The business memo format is best suited for presenting analysis and results of an issue that requires no morethan 2-3 pages of text and a couple of tables and exhibits. Anything longer should use a business report formatwith a very short transmittal memo).DATE: March 13, 2004TO: Martha Glamour, CEO Stylish Living MagazineFROM: Simpson and Lee Consulting Associates (This tells the reader your role as writer – e.g.consultant, analyst to reporting to manager, etc.)Thomas Simpson (Principal Writer) Richard Lee (Principal Editor). (The wordsprincipal writer and editor do not appear in a real business memo; they are here for gradingpurposes only. In the real world you would substitute the titles of the authors, e.g. Partner orSenior Manager).RE: Analysis of existing cost system and desirability of switching to ABC.Thank you for allowing us the opportunity to work with your company (simple courtesy and positivestart). As requested, we have evaluated the strengths and weaknesses of your company’s existingcost system and evaluated the desirability of switching from the existing cost system to anactivity based cost system ABC). (This sentence should clearly state the “big” issue in the case. It shouldalso help to remind the intended audience of the purpose of this memo). Our analysis uses Products X andY as test cases to understand how the existing and proposed ABC systems would computeproduct costs. Based on our study, we have reached the following conclusions:1. The cost of Product X is higher than Product Y under the current system; the cost Product X islower than Product Y under the ABC system.2. The existing cost system has several weaknesses that make the data unreliable and misleading.3. We recommend that the company should abandon the existing system and replace it with anactivity based cost system as it will provide better product cost information for decision making.(The three points above are what the writing guide refers to as “headlines”. They state the major conclusions ofyour memo and should (like a newspaper headline) grab the reader’s attention. Note a headline does not containdetailed results such as cost of Product X is $3.45 per unit.).The rest of this memo explains the basis of our conclusions. We will present our analysis in four parts.The first part deals with product cost under the existing system. This is followed by . . . The next section. . . The last section . . .(The purpose of these sentences is to give the reader a road map to follow your discussion. Note that the fourparts probably correspond to the detailed questions at the back of the case. These questions typically lead you toaddress the big issue in the case. If the memo is longer than 2 pages, you may have to use subheadings to avoidlong bodies of texts).Product Cost AnalysisOur analysis begins by computing the costs of the two products, X and Y, using the current cost system.Exhibit 1 shows the manufacturing cost of the two products under the existing cost system. As row 5shows, product X has a cost of $25.45 per unit. (Note the reader is being pointed to the data and not left tofind it for him or herself). Also, as column 3 of the Exhibit shows, most of this cost, approximately 65percent, is indirect manufacturing overhead. The last row of the Exhibit shows that . . . (Rest of the detailsomitted intentionally).Exhibit 1Costs of Manufacturing Product X and Product Y___________________________________Insert table here(Note that EXCEL tables and PowerPoint flowcharts can be pasted directly into your document. Make sure thatEXCEL tables fit the width of your page and PowerPoint flowcharts should be pasted as pictures(use the PasteSpecial command).___________________________________Weakness of Existing Cost SystemThe current system of assigning overhead to products using direct labor hours does not represent a fairmeasure of resources used by the products. Your company produces a large variety of products in lowvolume with highly automated operations. Direct labor accounts for only 3% of the total cost ofmanufacturing (See Exhibit 1). In your production environment, most of the indirect manufacturing costsare driven by cost drivers that have little or no relationship to the amount of direct content of eachproduct. The relevant cost drivers in your situation are . . . (Rest of the details omitted intentionally).Conclusion and Recommendations (Not you are reiterating what you said up front one more time). .We recommend that the company abandon its current cost system and replace it with . . . (Rest of thedetails omitted intentionally). This will allow you to better measure the resources consumed by eachproduct and lead to better pricing and product mix decisions . . . (Rest of the details omitted intentionally).

Order Solution Now