Assignment $6(1)($Protected View$)-$ Microsoft Word

Layout References Mailings Review View

nated from an Internet location and might be unsafe. Click for more details. Enable Editing

Assignment $6$

Due Date: November $21$

Bonus Points: $10$

You are required to use spreadsheet to do the assignment, save it as A$6$YourName, and submit it by the due date. Assignment in a format other than Microsoft Excel spreadsheet or equivalent will not be accepted. Late assignment will not be accepted either. Assignment solutions will be provided right after the due date. Turn in assignment on time to earn bonus points.

Do the following problem.

Fit Gym began January with merchandise inventory of $30$ bicycles that cost a total of $$2,400.$ During the month, Fit Gym purchased and sold merchandise on account as shown below:

$\backslash$table$[[,,$# of Units,Unit Cost,Sale Price$/$Unit$],[$Jan$.1,$Beginning Inventory,$30,80,],[18,$Purchase,$50,90,120],[26,$Sale,$40,,]]$

Requirements