You have been asked to develop a worksheet for Global
Steel to show its annual growth for the next five years based on the prior
year’s sales and growth data. Include an embedded 3-D Pie chart that shows the
contribution of each year’ gross margin to the total gross margin. Table 1 in
the following shows the data and general layout of the worksheet, with
assumptions. Table 2 provides the formulas to be used. Design and format the
worksheet and enter the formulas shown in Table 2 with proper cell references.
The values in the Total column should be calculated using the SUM function.
Table
1 Global Steel Sales Data with Assumptions
Sales for Year 0 (Prior Year’s Sales for Year 1) 26300000
Annual Growth Rate 2.250%
Annual Cost Rate 41.25%
Table
2 Global Steel Sales Projection Formulas
Formula A: Sales =
Prior Year’s Sales * (1 + Annual Growth Rate) |
Formula B: Cost
of Goods = Sales * Annual Cost Rate |
Formula C: Gross
Margin = Sales – Cost of Goods |
Get Free Quote!
314 Experts Online