Build and solve under Excel a production planning model for the following problem. You may want to use and adapt the template provided in Lecture 6 for the production of video cams (see below). A company produces skateboards in the US. The sales forecast in thousand of units for the coming year are given in the following table. The company can produce up 30,000 skateboards per month. As necessary, the company may augment its production by up to 50% through overtime working, but this increases the production cost for a skateboard from the usual $32 to $40. Currently there are 2,000 skateboards in stock. The inventory holding cost is estimated at $5 per unit held at the end of a month. Jan 30 Feb 15 March 15 April 25 May 33 June 40 July 45 Aug 45 Sep 26 Oct 14 Nov 25 Dec 30

B D E F H J 0 4 N Input data Month Demand Unit prod. Cost Unit inv. hold. Cost 550 1 470 150 25 580 190 3 620 185 15 5 610 160 16 6 580 170 14 155 12 10 Decision Variables production limit 600 600 600 600 600 600 600 250 270 250 300 290 310 Dashboard inventory held Production cost Inventory cost Total cost 120 606000 25280 631280