As a management scientist, is there anything you need to refine in this case model? Case...

Transcribed Image Text:

As a management scientist, is there anything you need to refine in this case model? Case 4 Case 5 Current Sales Current Sales Sales Level Increase Price Reduce Cost Qty Sold per day Qty Sold per mo. Selling Price Variable Cost Gross Profit per mo. Fixed Cost per mo. Salaries & Benefits Rent Utilities Logistics & Marketing Profit per mo. INPUT (calculated) INPUT INPUT (calculated) (calculated) INPUT INPUT INPUT INPUT OUTPUT Case 1 Current/ Status Quo 100 3,000 40 13 81,000 60,000 30,000 15,000 10,000 5,000 21,000 Case 2 Increase Sales to get 25k Profit 105 3,150 40 13 85,050 60,000 30,000 15,000 10,000 5,000 25,050 Case 3 Break-even 75 2,250 40 13 60,750 60,000 30,000 15,000 10,000 5,000 750 100 3,000 45 13 96,000 60,000 30,000 15,000 10,000 5,000 36,000 100 3,000 40 13 81,000 57,000 30,000 15,000 10,000 2,000 24,000 Share your thoughts! As a management scientist, is there anything you need to refine in this case model? Case 4 Case 5 Current Sales Current Sales Sales Level Increase Price Reduce Cost Qty Sold per day Qty Sold per mo. Selling Price Variable Cost Gross Profit per mo. Fixed Cost per mo. Salaries & Benefits Rent Utilities Logistics & Marketing Profit per mo. INPUT (calculated) INPUT INPUT (calculated) (calculated) INPUT INPUT INPUT INPUT OUTPUT Case 1 Current/ Status Quo 100 3,000 40 13 81,000 60,000 30,000 15,000 10,000 5,000 21,000 Case 2 Increase Sales to get 25k Profit 105 3,150 40 13 85,050 60,000 30,000 15,000 10,000 5,000 25,050 Case 3 Break-even 75 2,250 40 13 60,750 60,000 30,000 15,000 10,000 5,000 750 100 3,000 45 13 96,000 60,000 30,000 15,000 10,000 5,000 36,000 100 3,000 40 13 81,000 57,000 30,000 15,000 10,000 2,000 24,000 Share your thoughts!

Answer rating: 100% (QA)

Labelling The headers for each column or row could be clearer and more descriptive to make it easier ... View the full answer