ScenarioIn the Module Overview, we stated that an "aggregate plan will include the quantity and timing of production for the intermediate future (typically 3-18 months ahead).” Some factors such as demand, pay rate, and the ability to use overtime or subcontract some of the production must be taken into consideration to keep the total cost of production as low as possible.You have been asked to build the aggregate planning schedule for your factory for the next six months and to determine the best option.This chart provides the variables and cost for each variable.VariablesCostInventory carrying cost$7 per unit per monthSubcontracting cost$25 per unitAverage pay rate$12 per hour (8 hours per day)Overtime pay rate$18 per hour (above 8 hours per day)Labor-hours needed to produce one unit1.5 hours per unitUnits per day produced50Beginning inventory0Planned ending inventory0Lost sales per unit$30 This chart provides the demand for the product and the number of production days per month.MonthsDemandProduction DaysJanuary130022February80018March60021April150021May130022June130020Step 1: Prepare Your Aggregate PlanUse the Excel OM Aggregate Planning spreadsheet and the data to prepare your aggregate plan. Produce a graph of your plan. The intent is to use a level strategy (or level scheduling) with no overtime, no safety stock, and no subcontractors.Hint 1 - Consider that it takes 1.5 hours to produce a unit when determining your cost per unit for average and overtime pay.Hint 2 - To determine regular time production, you need to multiply the units per day produced by the number of production days.Continue to Step 2: Update Your Aggregate Plan Using OvertimeStep 2: Update Your Aggregate Plan Using OvertimeIn the plan produced in Step 1, the production rate did not meet the total demand. If you were able to use overtime to meet the shortfall, what would your aggregate plan look like?Use the Excel OM Aggregate Planning spreadsheet and the data to prepare an updated aggregate plan.Continue to Step 3: Update Your Aggregate Plan Using OutsourcingStep 3: Update Your Aggregate Plan Using OutsourcingInstead of paying overtime, you might be able to outsource the shortfall in production. Use the Excel OM Aggregate Planning spreadsheet and the data to prepare an updated aggregate plan using outsources instead of paying overtime.Continue to Step 4: Summarize and SubmitStep 4: Summarize and SubmitOn a fourth tab of the spreadsheet, summarize your cost and determine which of the three options produces the lowest overall cost. Be sure to provide a detailed analysis along with your summary data.Submit one spreadsheet containing a tab for each step. Save your assignment using a naming convention that includes your first and last name and the activity number (or description). Do not add punctuation or special characters.Review the Problems Rubric for detailed grading information.

Please complete this mini case using the attached files.Mini Case: Goodweek Tire, Inc.Resources Mini Case: Goodweek Tire, Inc. Scoring Guide.For this assignment, complete the mini case, "Goodweek Tires, Inc.," located in Chapter 6, pages 206–207 of your Corporate Finance text. This mini case focuses on a company that is looking to produce and market a new product. You are asked to take on the role of a financial analyst to evaluate the project of producing and marketing the product, and to provide recommendations on whether or not the project would be a good investment.As you complete the assignment, make sure that you use the materials presented in this course to justify your answers. The optional activities provided in this unit, and possibly the optional finance problems in the previous unit, may help you with completing this mini case. Refer to the Mini Case: Goodweek Tires, Inc. Scoring Guide to ensure you have met the expectations of this assignment.