a) Formula
Total Cost for polo shirt - =c4*d4
Total points - =E4*10
b) Calculation of total cost and total points
Items | Quantity | Cost | Total cost | Total points |
Polo shirt | 3 | $50 | $150 | $1500 |
Dress shirt | 4 | $75 | $300 | $3000 |
Khakis | 2 | $59.99 | $119.98 | $1199.8 |
Merell shirt | 1 | $135 | $135 | $1350 |
Snowline Jacket | 1 | $219 | $219 | $2190 |
Belt | 1 | $19.99 | $19.99 | $199.9 |
Cloud layer fleece | 2 | $75 | $150 | $1500 |
Sweater | 3 | $80 | $240 | $2400 |
Full zip hoodie | 1 | $70 | $70 | $700 |
Wrinkle Free oxford | 5 | $55 | $275 | $2750 |
Total | $1678.97 | $16789.7 |
c) Calculation of gift certificates and its value
One gift certificate of $15 for 2550 points
Formula for number of gift certificates - =INT(F15/2550)
Gift certificate = 6 Certificate
Formula for Value of gift certificates - =F17*$15
Value of gift certificates = 6*$15 = $90
d) Ratio of money spent to value of gift certificates
Formula for ratio = E15:F18
Ratio = $1678.97:$90
ROTECTED VIEW Be cavefulles from the Internet can contain viuses. Unless you need to ndit, it's...
Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View -ut interruption, please reactivate now. Reactivate Enable Editing MERIWELL COMPANY I Finished goods inventory, beginning Finished goods inventory, ending Depreciation, factory Administrative expenses Utilities, factory Maintenance, factory Supplies, factory Insurance, factory Purchases of raw materials Raw materials inventory, beginning Raw materials inventory, ending Direct labour Indirect labour Work in process inventory, beginning Work in process inventory, ending Sales Selling expenses $20,000 40,000 27,000 110,000...
Enable Editing (0) PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit it's safer to stay in Protected view K19 DK 1 CD5 - EXCEL Tutorial 3 CURRENT DESIGNS 4 Bill Johnson, sales manager, and Diane Buswell, controller at Current Designs are beginning to analyze the cost 5 considerations for one of the composite models of the kayak division. They have provided the following production 6 and operational costs necessary to produce one composite...
ROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit Recerding sapplies and ideatifing their dfect on finenciel stetemeats Exercise 13-108 LO 13-1, 13-3, 13-4 Laurs Moss started and operated a small family consuking firm in Year L The firm was aflected by two events (1) Moss provided $36,000 of services on acount, and (2) she purchased $10,000 of supplies on account. There were $1800 of supplies on hand as of December 31, Year L...
met can contain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing Alex quit his job at State University where he earmed $45,000 a year to start extreme gaming software business To start the business, he cashed in $100,000 in bonds that was earning him 10 percent interest anmually to buy equipment. His forgone entrepreneurial income was $5,000 a year. In the first year, the fim sold 11,000 units of software at $75 for...
Home Insert Page Layout Formulas Dats Reve ROTECTED VIEW Be careful fFiles from the Internet can contain vinuses. Unless you need to edit, it's saler to stay in Protected View C D Strength 48.5 52.3 53.5 50.5 50.3 49.6 The CEO of Durable Bags Inc. is planning to introduce a new, improved version of the company's trash bag. The new trash bag utilizes a new formula that is being touted as the strongest bag on the market Previously, one of...
et can contain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing Case: Cost Structures for Global Shippers Inc. Management from Global Shippers Inc, an interational shipping business, is in the process of assessing the choice between two different cost structures for the business. Option A has relatively higher variable costs per unit shipped but lower annual fixed costs, while Option B has the opposite relatively lower variable costs in its cost structure but...
References Mailings Review View Help nternet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing Q6. Dollarama Inc, completed the following transactions during November 2019, its first month of operations: Nov. 1 Received $25,000, and issued common shares. Nov.5 Purchased $800 of office supplies on account. Nov. 6 Paid $20,000 cash for land to use as a building site. Nov. 10 Performed service for customers, and received cash of $5,000. Nov. 15...
i just need 10 and 12 answered!!! Thank you! Are you reading from a computer or a cellphone? They are clear on my computer just need 10 and 12 answered pls The Business Situation When Shelley Jones became president-elect of the Circular Club of Auburn, Kansas, she was asked to suggest a new fundraising activity for the club. After a consider- able amount of research, Shelley proposed that the Circular Club sponsor a pro- fessional rodeo. In her presentation to...