1 / 7

Application Exercises

Application Exercises. MGS 3040 Sec. 04 Chapter # 3 Page # 87 Question 1. Group Members: Michelle Barborino Abbas Kazmi Jihua liu Brenden Luuney Betty Myhand. Make the first two rows of your spreadsheet similar that in Figure 3-7 (Pg. 87). Place the current date so that it is centered.

cheng
Download Presentation

Application Exercises

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Application Exercises MGS 3040 Sec. 04 Chapter # 3 Page # 87 Question 1 • Group Members: • Michelle Barborino • Abbas Kazmi • Jihua liu • Brenden Luuney • Betty Myhand

  2. Make the first two rows of your spreadsheet similar that in Figure 3-7 (Pg. 87) Group ‘C’ Presentation - Bicycle Rental (Page 87 Quest. 1)

  3. Place the current date so that it is centered Group ‘C’ Presentation - Bicycle Rental (Page 87 Quest. 1)

  4. Use the formulas for Calculations Group ‘C’ Presentation - Bicycle Rental (Page 87 Quest. 1)

  5. Three Examples of decisions that management can make using this data. • Management can increase the number of “Wonder Bike II” bicycles because of its high revenue as percent of cost of inventory. • Management can reduce the number of “LiteLift Pro” bicycles because of its low revenue as percent of cost of inventory. • Management can consider replacing “LiteLift Pro” with “Wonder Bike Supreme” of with “Wonder Bike” because of their demand. Group ‘C’ Presentation - Bicycle Rental (Page 87 Quest. 1)

  6. Use the formulas for Calculations Group ‘C’ Presentation - Bicycle Rental (Page 87 Quest. 1)

  7. Other Useful Calculations We added the “Profit Per Bike” Column. This shows how much net profit the store earns per bike. We found this out by taking the revenue per bike and subtracting the cost of the inventory. After that, we divided that by the number on hand.

More Related