Example 1.5 in Chapter 5 provided data from an experiment to identify the relationship between sales and pricing, coupon, and advertising strategies. Enter the data into a spreadsheet and implement the model in the example within your spreadsheet to estimate the sales for each of the weekly experiments. Compute the average sales for the three stores, and find the differences between the averages and the model estimates for each week.

9. Develop a spreadsheet model for Problem 12 in Chapter 1, using the data provided.

Apply the principles of spreadsheet engineering in developing your model.

10. Develop a spreadsheet model for Problem 13 in Chapter 1. Apply the principles of spreadsheet engineering in developing your model. Use the spreadsheet to create table for a range of prices to help you identify the price that results in the maximum revenue.

12. MasterTech is a new software company that develops and markets productivity software for municipal government applications. In developing their income statement, the following formulas are used:

gross profit = net sales -cost of sales

net operating profit = gross profit - administrative expenses -selling expenses

net income before taxes = net operating profit -interest expense

net income = net income before taxes-taxes

Net sales are expected to be $900,000.00. Cost of sales is estimated to be $540,000.00.

Selling expense have a fixed component that is estimated to be $900,000.00 and a variable component that is estimated to be 7% of net sales. Administrative expenses are $50,000.00 Interest expenses are $10,000.00. The company is taxed at a 50% rate.

Develop a spreadsheet model to calculate the net income. Design your spreadsheet using good spreadsheet-engineering principles.