Jakes Furniture sells the following items in his store:

Extended Sofa Beds, with a cost of $2,395

Floor Lamps with a cost of $795

Couches with a cost of $1,535

Dining Room Sets with a cost of $1,250

Office Desks with a cost of $3,045

He has a markup of 35% on all items.

He asks you to set up a workbook that will show the Total Sales for each item.

During the month of January he sold:

23 Sofa Beds

128 Floor Lamps

50 Couches

531 Dining Room Sets

53 Office Desks

Jake needs to see the following on the worksheet:

Product

Cost

Markup

Price

Quantity

Total

Use formulas so that if the Markup, Price or Quantity is changed, the Total column automatically updates. Also include a grand total for all sales.

Create separate tabs for Value View and Formula View and name the tabs Sales (value or formula).