71155 After doing some research, you estimate the predictions below. Using the figures in Table 1: Business Computing Assessment 3, OP, NZ

Task 2:
a) After doing some research, you estimate the predictions below. Using the figures in Table 1, uses functions and formulas to calculate the correct numbers in the prediction worksheet.

Table 1: Projections for proposed scenarios

b) Create a pivot table and bar graph chart to show only the net profit for the year 2021, selling via a website and expanding the product offering.

c) Once completed, advise Rea (Cell A35) if you think that Lux Lights should focus on selling online via a company website, or expand the product offering. Use the spreadsheet numbers to explain your recommendation.