Please show worked out solutions step-by-step in excel

: AK Enterprises had collected the following information related to one of its major products Regular production available : 1400 units Regular production cost : $10 per unit Undertime production cost" : $5 per unit Overtime production cost : $15 per unit Average Inventory costs : $3 per unit per period (Use average inventory) Backorder costs : $7 per unit per period Beginning inventory : 200 units Quarterly demand : 2000, 1500, 1300, 1800 * this is the penalty for not using the regular production available (i.e. capacity) 1. Compute the total costs associated with a chase production plan 2. Compute the total costs associated with a level production plan