Please show work in excel with formulas showing as well

PROBLEM 6 (Lesson 9 Linear Programming) Computer Productions produces thrce keyboards: Regular, Special and Collector. The following cost data is available: Computer Productions fixed manufacturing costs are $20,000 per month. Based on an estimated monthly production of 400 units, they have assigned $50 of fixed costs per unit to cach keyboard produced, regardless of the type of keyboard. The marketing and distribution is fully outsourced to another company and Computer Productions has agreed on a price per unit for both marketing and distribution. The maximum demand for Regular keyboards is 250 units per month. The maximum demand for Special keyboards is 30 units per month. Computer Productions want to keep the Collector keyboard sales down to keep it a collector's item. Therefore the sales can he no more than 50% of the Regular kcyboard sales. (Hint: You must create a constraint for this condition). Direct manufacturing labor hours are limited to 10,500 hours per month. Machine hours are limited to 5,100 hours per month. The Regular keyboard requires 20 hours of labor and 8 machine hours. The Special keyboard requires 34 hours of labor and 25 machine hours. The Collector keyboard requires 37 hours of labor and 22 machine hours. Management desires a product mix that will maximize the contribution margin towards fixed costs and profits given the constraints. Where: R= Regular keyboards S= Special keyboards C = cullector keyboards PROBLEM 6 (Lesson 9 Linear Programming) Computer Productions produces thrce keyboards: Regular, Special and Collector. The following cost data is available: Computer Productions fixed manufacturing costs are $20,000 per month. Based on an estimated monthly production of 400 units, they have assigned $50 of fixed costs per unit to cach keyboard produced, regardless of the type of keyboard. The marketing and distribution is fully outsourced to another company and Computer Productions has agreed on a price per unit for both marketing and distribution. The maximum demand for Regular keyboards is 250 units per month. The maximum demand for Special keyboards is 30 units per month. Computer Productions want to keep the Collector keyboard sales down to keep it a collector's item. Therefore the sales can he no more than 50% of the Regular kcyboard sales. (Hint: You must create a constraint for this condition). Direct manufacturing labor hours are limited to 10,500 hours per month. Machine hours are limited to 5,100 hours per month. The Regular keyboard requires 20 hours of labor and 8 machine hours. The Special keyboard requires 34 hours of labor and 25 machine hours. The Collector keyboard requires 37 hours of labor and 22 machine hours. Management desires a product mix that will maximize the contribution margin towards fixed costs and profits given the constraints. Where: R= Regular keyboards S= Special keyboards C = cullector keyboards