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

business

Description

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

Instruction Files

Related Questions in business category