Wheels Up Bags manufactures a variety of bags. Wheels Up has just received a special order for a large volume of bags at reduced, special order prices. The following is a screenshot of the special order in an Excel file in a worksheet named SpecialOrder.

To follow is a sample from WheelsUp’s job cost records from the most recent month from a worksheet named JobCostRecords. The list is sorted chronologically with the most recent orders first. This job cost records worksheet contains 408 job cost records.

Another worksheet contains descriptions for each of the model numbers. The following screenshot is from the Descriptions worksheet.

Requirement 

1. Use the VLOOKUP function in Cells B2 through B11 in the Special Order worksheet to look up the description for each special order item in the Descriptions worksheet.
2. Use the VLOOKUP function in Cells F2 through F11 in the Special Order worksheet to look up the most recent variable cost for each item in the Job Cost Records worksheet.
3. Enter the formula to calculate contribution margin per pack in Cells G2 through G11 in the Special Order worksheet.
4. Calculate the total contribution margin from the special order in Cell H12 in the Special Order worksheet.
5. Should the company accept this special order?

Transcribed Image Text:

Model # 1 2 B9876 3 C98753 4 G05489 5 G7894 6 C4547 7 B4587 8 R4861 9 R98547 10 R9687 11 R7894 12 B Description Quantity Price per bag 100 $ 100 $ 100 $ 75 $ 100 $ 75 $ 200 $ D 100 $ 100 $ 200 $ Total Revenue 42 $ 45 $ 40 $ 60 $ 35 $ 50 $ 102 $ E 110 $ 120 $ 48 $ 1,500 2,000 2,625 2,750 1,875 2,250 8,400 8,000 7,875 7,050 Variable cost per bag G Contribution margin per bag H Total contribution margin