General Motors (GM) has just started manufacturing a new electric vehicle (EV). The table below shows the demand forecast for the next 5 periods (quarters) for this EV. manufactured by GM. The costs involved in manufacturring are as follows: Regular Time =$10,000 per car. Overtime =$20,000 per car. Inventory Costs =$1000 per car per period on average inventory. Back order Costs =$2000 per car per period. Planners for GM are about to prepare an aggregate plan that will cover the next 5 periods. They want to evaluate a plan that calls for a steady rate of regular-time output of 4000 cars, mainly using inventory to absorb the uneven demand but allowing some backlog. Overtime and subcontracting are not used because they want steady output. They intend to start with zero inventory on hand in the first period. Prepare the aggregate plan for the next 5 periods for GM. Follow steps exactly similar to those in the aggregate plan for skateboards example discussed in class (refer to the post Monday slides in Week 10). First, develop the table that computes output, inventory, backlog etc. Next, develop the table that computes the output, inventory, and backlog costs. Both the tables you develop should have all the rows Prepare the aggregate plan for the next 5 periods for GM. Follow steps exactly similar to those in the aggregate plan for skateboards example discussed in class (refer to the post Monday slides in Week 10). First, develop the table that computes output, inventory, backlog etc. Next, develop the table that computes the output, inventory, and backlog costs. Both the tables you develop should have all the rows and columns as in the tables discussed in the skateboards example. You can write your tables on a paper, scan/take a picture and upload the file. You can also type the table in a document and upload the file. Use the "Add File" button below to upload your file. Please write your work clearly and legibly