Hello, I have a Business Intelligence and Analytics assignment that I need help with. If you are going to accept this assignment make sure to include a separate document explaining the work, I want to learn this. I am posting this because I don't understand how to do this.

An Excel sheet showing the calculation should be included. please ensure all areas are completed to the highest standards, I will not accept poor work, but I will add an extra tip for very high-quality work.

The details of the assignment are in the attached file

 

A small business produces 3 types of cables: A, B, and C. The cost of in-house produc±on is es±mated tobe $6, $12, and $10 per foot of A, B, and C respec±vely. The manufacturing process requires machiningand Fnishing. The machining and Fnishing ±me needed to produce a foot of each type of cable arepresented in the table below.²or the coming produc±on period the Frm is contractually obligated to produce 60,000 feet of A, 80,000feet of B, and 90,000 feet of C. As only800 hours of machine tmeand400 hours of Fnishing tmeareavailable, these demands cannot be met by in-house produc±on alone. The Frm has the op±on ofprocuring these cables from an external supplier in order to meet the demand. The cost prices (from theexternal supplier) per foot of cable are as follows: $8 for A, $15 for B, and $12 for C.The produc±on manager has to decide how much of each type of cable to produce in-house and howmuch to purchase from the external supplier in order to meet the demands exactlyand minimize totalcost. The data is summarized below:Cable TypeABCDemand (f)60,00080,00090,000Producton Cos±/f$6$12$10Procuremen± Cos±/f$8$15$12Machine tme needed (mins/f)0.500.500.60Finishing tme needed (mins/f)0.600.200.401.Formula±e ±he problem as a Linear Program:Decision Variables:Objec±ve ²unc±on:Constraints:

Attachments:

• 1495275553-BI work.docx