Your company has just acquired a new subsidiary that makes two products, Clodhopper and Clodbuster. The Clodhopper is intended for the general consumer market and its demand is higher and more seasonal than the Clodbuster, which is intended for the commercial user market. Both products share a number of component parts and subassemblies, primarily differing in their engine and tiller subassemblies. All of the managers at the acquired company quit the day your company took possession. You are the person who has been assigned to run this acquisition. Since all of the managers quit, the only planning information you have is historical data.
Your task is to create two aggregate plans for 2015: a plan using the chase strategy, and a plan using the mixed strategy (level production with inventory).
â€¢ Use the aggregate planning form supplied and print the spreadsheets (landscape) one to a page. Spreadsheets must be formatted to fit the entire spreadsheet on a single page. Fill in all appropriate data, including the title of the plan.
â€¢ Do not make any changes to the format/layout of the spreadsheet. This is one place in industry where creativity in presenting data is not appreciated since many of the cells in the forms are normally linked, and changes can lead to significant errors in the results.
â€¢ Size the printout so that it fills the page from side-to-side (no extraneous white space). Delete extraneous items from your printout (e.g. â€œUse this form for your
aggregate plansâ€). Check and correct your printout for cut-off words, e.g.
â€¢ Plans must follow the requirements exactly. Do not attempt to make your plans â€œbetterâ€ by changing the planning strategy (for example, if the chase plan requires firing everyone one month and hiring them back the next month, show that in your plan
â€¢ Plans must meet all the operating constraints given in the â€œPart 1 Dataâ€ section below.
â€¢ Use the comment function to show the formula for Shipments. This must cover the case for months when supply exceeds demand, and the case for months when demand exceeds supply. (Review â€“ New comment â€“ Show all comments ** and ** Page layout â€“ Page setup [click on dialog box launcher in lower right corner] â€“ Sheet â€“ Comments â€“ As displayed on sheet). Handwritten notes are not acceptable.
â€¢ Use the header function to show your name in the upper right corner of both plans (Print preview â€“ Page setup â€“ Header/footer â€“ Custom header).
â€¢ Create a cover page (portrait) using the format below. Note that the cost/unit produced is the total cost (staffing, hire/fire, inventory/backlog, and material cost).
Fill in the cover page
â€¢ Submit your completed assignment with the cover page (executive summary), the chase plan as the second page, and the mixed plan as the third page. Staple portrait pages in the upper left corner and landscape pages in the upper right corner as shown:
Part 1 Data:
Use the forecast provided and the following information to create your aggregate plans:
? Values in the spreadsheet (demand, production rates, staffing levels, etc.) are to be number of units or people (not $). They are to be expressed in whole numbers (no decimal values). Costs will appear in the last row and the upper right hand corner of the spreadsheet only. Cost calculations, of course, will need to retain at least 2 decimal points (cents) but whole $ should be reported.
? Assume 20 production days per month (4 weeks of 5 days each)
? The production level in December 2013 was 6000 units per month
? The ending inventory level for December 2013 (8400 units) is the beginning inventory for January 2014
? Desired safety stock inventory level is 1000 units, but this level to subject to the other operating constraints
? Desired inventory at the end of the year (after December 2014 demand is satisfied) is 2000 units, but this level is subject to the other operating constraints
? The maximum level of inventory that the firm can store at one time is 19,500 units
? The maximum level of production in the facility in any month is 24,000 units.
? You must use whole people â€“ there are no part time employees. Employees do not produce more per month than is required by the plan.
? The chase plan and the mixed (level production with inventory) plan are to consider only regular production (employees working 40 hours per week with no overtime).
? Plans must meet all forecasted demand for the year.
? Cost Information:
Inventory holding cost $7 per unit per month based on ending inventory for month
Backorder cost $9 per unit per month based on ending backorder level in a month
Costs of hiring one additional employee $4000
Costs of firing one employee $2500
Average pay rate $8 an hour
Labor to produce one unit 80 minutes (one employee can produce 120 units per month)
Material cost to produce one unit $31
? If you can not meet all forecast demand in a month, ship everything that you can (do not hold safety stock if you are in backlog). Show any shortfall as backlog, not as negative inventory (e.g. short by 200 units: on-hand inventory = 0, backlog = 200, [inventory â€“ backlog] = â€“200).
? Show backlog as a cumulative total (e.g. if the following month you are short an additional 300 units, backlog would be 500 units, and [inventory â€“ backlog] would be â€“500. Ship the backlog when you can.
? Materials units = Regular production units (show units, not $ in this column). This column is included so that the cost calculations will be straightforward (total cost = staffing cost + hire cost + fire cost + inventory cost + backlog cost + material cost)
? Show all cost calculations in the bottom row, and show the total cost in the upper right corner of the spreadsheet.
Our Service Charter
Excellent Quality / 100% Plagiarism-FreeWe employ a number of measures to ensure top quality essays. The papers go through a system of quality control prior to delivery. We run plagiarism checks on each paper to ensure that they will be 100% plagiarism-free. So, only clean copies hit customers’ emails. We also never resell the papers completed by our writers. So, once it is checked using a plagiarism checker, the paper will be unique. Speaking of the academic writing standards, we will stick to the assignment brief given by the customer and assign the perfect writer. By saying “the perfect writer” we mean the one having an academic degree in the customer’s study field and positive feedback from other customers.
Free RevisionsWe keep the quality bar of all papers high. But in case you need some extra brilliance to the paper, here’s what to do. First of all, you can choose a top writer. It means that we will assign an expert with a degree in your subject. And secondly, you can rely on our editing services. Our editors will revise your papers, checking whether or not they comply with high standards of academic writing. In addition, editing entails adjusting content if it’s off the topic, adding more sources, refining the language style, and making sure the referencing style is followed.
Confidentiality / 100% No DisclosureWe make sure that clients’ personal data remains confidential and is not exploited for any purposes beyond those related to our services. We only ask you to provide us with the information that is required to produce the paper according to your writing needs. Please note that the payment info is protected as well. Feel free to refer to the support team for more information about our payment methods. The fact that you used our service is kept secret due to the advanced security standards. So, you can be sure that no one will find out that you got a paper from our writing service.
Money Back GuaranteeIf the writer doesn’t address all the questions on your assignment brief or the delivered paper appears to be off the topic, you can ask for a refund. Or, if it is applicable, you can opt in for free revision within 14-30 days, depending on your paper’s length. The revision or refund request should be sent within 14 days after delivery. The customer gets 100% money-back in case they haven't downloaded the paper. All approved refunds will be returned to the customer’s credit card or Bonus Balance in a form of store credit. Take a note that we will send an extra compensation if the customers goes with a store credit.
24/7 Customer SupportWe have a support team working 24/7 ready to give your issue concerning the order their immediate attention. If you have any questions about the ordering process, communication with the writer, payment options, feel free to join live chat. Be sure to get a fast response. They can also give you the exact price quote, taking into account the timing, desired academic level of the paper, and the number of pages.