Assuming this case model is already fine, what do you think is the best to budget...

Transcribed Image Text:

Assuming this case model is already fine, what do you think is the best to budget for? Case 1 Case 3 Case 4 Case 5 Current/ Break-even Current Sales Current Sales Sales Level Increase Price Reduce Cost Status Quo Qty Sold per day Qty Sold per mo. Selling Price Variable Cost Rent Utilities Logistics & Marketing INPUT Profit per mo. (calculated) Gross Profit per mo. (calculated) Fixed Cost per mo. (calculated) Salaries & Benefits INPUT INPUT INPUT INPUT INPUT INPUT OUTPUT 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 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 1. Establish 3,000 40 13 15,000 10,000 To arrive at a business decision: 2,000 81,000 57,000 3. Rationalize and Select best 30,000 alternative 24,000 criterion/criteria 2. Evaluate each alternative against each criterion Share your thoughts! Assuming this case model is already fine, what do you think is the best to budget for? Case 1 Case 3 Case 4 Case 5 Current/ Break-even Current Sales Current Sales Sales Level Increase Price Reduce Cost Status Quo Qty Sold per day Qty Sold per mo. Selling Price Variable Cost Rent Utilities Logistics & Marketing INPUT Profit per mo. (calculated) Gross Profit per mo. (calculated) Fixed Cost per mo. (calculated) Salaries & Benefits INPUT INPUT INPUT INPUT INPUT INPUT OUTPUT 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 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 1. Establish 3,000 40 13 15,000 10,000 To arrive at a business decision: 2,000 81,000 57,000 3. Rationalize and Select best 30,000 alternative 24,000 criterion/criteria 2. Evaluate each alternative against each criterion Share your thoughts!

Answer rating: 100% (QA)

It looks like you have a set of financial data for 5 different scenarios and yo... View the full answer