Assignment: Complete parts 1, 2, and 3 using Microsoft Excel tools. You should have each part of the problem on its own sheet.

Part 1: Build a spreadsheet model for FashionTech to perform What-If analysis.

You are given the following information for part 1 of the case: ObjectiveProfit

Decision Variable:

Number of Tailors - 4

Uncertain Variable

Weekly Demand for Jackets Start at 140 units

other Details

Price of Jacket - $50Material

Cost per Jacket - $12

Production Rate per Tailor 35

jacketsWage per Tailor per Week - $700O

overhead Cost for Production - $800

Task:1. Create a spreadsheet model to calculate profit for FashionTech

2. Create a two-way data table to evaluate changing the number of tailors between 2, 3, 4, 5, and 6 and the weekly demand between 100, 140, 180, and 220(continued on next page)