EXHIBIT 1 A boat builder is planning its production mix for…
EXHIBIT 1 A boat builder is planning its production mix for next year. It produces luxury motor boats (x1) and sailboats (x2). The company has to decide how many of each type of boats to build in order to maximize its annual profit. A motor boat has a profit contribution of $50,000, and a sailboat has a profit contribution of $30,000. A motor boat requires 1,000 hours of labor and a sailboat requires 500 hours of labor. The company has a total of 80,000 hours of labor available. On average, the cost of advertising a motor boat is $2,000, and the cost of advertising a sailboat is $4,000 (more expensive because of different marketing channels). The company has an annual advertisement budget of maximum $400,000. Finally, the company has a maximum of $18,000,000 to invest in building these boats. A motor boat costs $200,000 to build, and a sailboat $150,000. The decision variables are defined as: x1 = Number of motor boats to build x2 = Number of sailboats to build Motor boat (x1) Sailboat (x2) Profit contribution $50,000 $30,000 Labor required 1,000 h 500 h Advertising cost $2,000 $4,000 Investment needed $200,000 $150,000 Please solve the problem described in this Exhibit using the Excel Solver. You will find the template for this problem in the file Final Exam_Exhibit 1_DATA.xlsm Important: When clicking on this link, if the file does not open you will find it in the “download” section of your browser (bottom left of the page) and you can open it from there. If it still does not open, make sure that you are not editing a formula in another Excel file (this sometimes prevents you from opening a new file). Please note that this file is protected against saving. Do not close this file until you submit the exam, otherwise you may loose its content. In case you inadvertently closed the file, please download it again.
Read DetailsEXHIBIT 6 The file Final Exam_Exhibit 6_DATA.xlsm contains t…
EXHIBIT 6 The file Final Exam_Exhibit 6_DATA.xlsm contains the inventory and annual sales data of a retailer. Please create an ABC analysis of this inventory data, and use it to respond to the following questions. For this Exhibit, assume the following thresholds for the categorization of SKUs: Type A: 20% of SKUs with highest dollar usage Type B: 30% of SKUs with medium dollar usage Type C: 50% of SKUs with lowest dollar usage Important: When clicking on this link, if the file does not open you will find it in the “download” section of your browser (bottom left of the page) and you can open it from there. If it still does not open, make sure that you are not editing a formula in another Excel file (this sometimes prevents you from opening a new file). Please note that this file is protected against saving. Do not close this file until you submit the exam, otherwise you may loose its content. In case you inadvertently closed the file, please download it again.
Read DetailsEXHIBIT 3 A craft brewery is planning its production for the…
EXHIBIT 3 A craft brewery is planning its production for the summer season. It has assessed demand data for the next three months (see table below). With its current equipment, the company can brew between 18,000 and 26,000 gallons beer per month. The brewery has storage space that can hold maximum 10,000 gallons of beer. The cost of storing beer is $1.10 per gallon per month. The inventory is empty at the beginning and end of the planning period. The brewing cost is estimated at $3.20 per gallon. The brewery wants to find the optimal production schedule that minimizes its total cost. The decision variables are given as: B1 = Number of gallons brewed in Month 1 B2 = Number of gallons brewed in Month 2 B3 = Number of gallons brewed in Month 3 S1 = Number of gallons in inventory at end of Month 1 S2 = Number of gallons in inventory at end of Month 2 Demand Month 1 15,000 gallons Demand Month 2 21,000 gallons Demand Month 3 36,000 gallons Minimum brewing per month 18,000 gallons Maximum brewing per month 26,000 gallons Maximum storage capacity per month 10,000 gallons Brewing cost per gallon 3.20 $/gallon Storage cost per gallon 1.10 $/gallon Please solve the problem described in this Exhibit using the Excel Solver. You will find the template for this problem in the file Final Exam_Exhibit 3_DATA.xlsm. Important: When clicking on this link, if the file does not open you will find it in the “download” section of your browser (bottom left of the page) and you can open it from there. If it still does not open, make sure that you are not editing a formula in another Excel file (this sometimes prevents you from opening a new file). Please note that this file is protected against saving. Do not close this file until you submit the exam, otherwise you may loose its content. In case you inadvertently closed the file, please download it again.
Read Details