Question: PLEASE SOLVE IN EXCEL USING SOLVER AND SHOW THE FORMULAS USED!! Im not sure how to do part A or B. I think I have

PLEASE SOLVE IN EXCEL USING SOLVER AND SHOW THE FORMULAS USED!!
Im not sure how to do part A or B. I think I have my spreadsheet set up wrong. Any help is appreciated! PLEASE SOLVE IN EXCEL USING SOLVER AND SHOW THE
PLEASE SOLVE IN EXCEL USING SOLVER AND SHOW THE
company 6.8 Allocating Components to Assemblies: Biking.com is a web-based.com that sells bicycles on the Internet. Its distinctive feature is that it allows tomers to customize the design when they order and then to receive quick suspension (standard or heavy-duty), and gear speeds (5, 10, 15). As a result, delivery. Biking.com gives customers choices for frame size (34,36,3 shorthand refers to frame size as Option A (A1 is the 34-in. model, A2 is the customers can order one of 18 possible combinations (3x2x3). The 36-in. model, and A3 is the 38-in. model). Similarly, the standard suspension is option B1, and the heavy-duty suspension is B2. The gear speeds are C16, c2 (10), and C3 (15). Rather than stock 18 different types of bicycles, the company holds inventories of the major components and then assembles the bikes once a customer order comes in. Orders are taken Mondays through Wednesdays, assemblies are done on Thursdays, and shipments go out an Fridays. Thus, at the close of business on Wednesday, the company has an inventory of components and a list of orders, and its task is to match compo nents with orders to meet as much demand as possible. The tables below describe customer orders for this week and the inventory status at the end of Wednesday. 3 Model 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 A 1 1 1 1 1 1 2 2 2 2 2 2 3 3 B 1 1 1 2 2 2 1 1 2 2 2 1 3 1 2 3 1 2 1 2 05 6 3 1 1 2 3 1 2 3 1 Orders 4 5 0 5 1 7 0 4 8 3 3 3 2 2 2 1 29 0 15 4 Component Inventory A1 A2 A3 B1 B2 c1 18 C2 C3 16 20 12 20 30 20 25 (a) What is the maximum number of customer orders that can be satisfied this week? (b) Suppose that the profitability varies by model type, as shown in the table below. What is the maximum profit that can be achieved from this week's orders? Model 1 2. 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 Profit 45 55 70 65 75 90 47 57 72 67 77 92 50 60 75 70 80 95

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!