Question: I'm having a hard time figuring out the formula for question 4. of this document. In my spreadsheet, I have the cost and total sales

I'm having a hard time figuring out the formula for question 4. of this document. In my spreadsheet, I have the cost and total sales for the year. It's given that the profit margin for each item is .05 and Mary buys from the lowest cost supplier.

The closest I've come is

=(sales*.05)-sales / 52

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

I'm having a hard time figuring out the formula for question 4. of this document. In my spreadsheet, I have the cost and total sales for the year. It's given that the profit margin for each item is...

Q:

I need help solving my accounting project. i did 4-7 workbook which i have attached below. but 7-10 are incorrect. could someone help me correct from 7-10 quickly please. MI5965 I SEE THE LIGHT...

Q:

I need help solving my accounting project. i did 4-7 workbook which i have attached below. but 7-10 are incorrect. could someone help me correct from 7-10 quickly please. MI5965 I SEE THE LIGHT...

Q:

I really need help with the questions on sheets 3,4,5, and 6. I've attached the project below for the problems. Thank you so much! CS1207 I SEE THE LIGHT www.cybertext.com, The Book List, Building...

Q:

All data is there Just looking to check the correct answers!! and please give me a hint on what each ratio means in regards to the industry ratio and how the company can better that ratio. (biggest...

Q:

Please help me complete the attached assignment. Use the word document to help fill out the excel spreadsheet. I have already started on the first tab, please check to make sure my answers are...

Q:

so the full instruction is updated and psoted, also, the answers to tvis supposed to be based on a previous worksheet. i attached the answers to the worksheet, 1-3 that is needed to answer this...

Q:

I need some help explaining these charts please. The first page is a financial statement for Apple inc. the second page is a projected statement for Apple Inc. I have to do a talk over on my...

Q:

WEEK # 1 - EXERCISES Exercise 1 You oversee a young and growing business. You have identified the various factors (sources of revenue and expenses) that influence the business as shown in the table...

Q:

WEEK # 1 - EXERCISES Exercise 1 You oversee a young and growing business. You have identified the various factors (sources of revenue and expenses) that influence the business as shown in the table...

Q:

(Issuance of Bonds with Stock Warrants) On May 1, 2010, Barkley Company issued 3,000 $1,000 bonds at 102. Each bond was issued with one detachable stock warrant. Shortly after issuance, the bonds...

Q:

What is the common characteristic of all the assets owned by a company? Intangible Long Life Future Economic Benefits None of the above

Q:

Question Content Area Statement of Cash Flows The following is a list of the items to be included in the preparation of Warrick Company's 2 0 1 9 statement of cash flows: Net income, $ 4 2 , 0 0 0...

Q:

4 5 7 8 Irish Pub Staffing Total number of servers Revenue @ $600 per server $ 2,400.00 Wages @$96.00 per server $ 384.00 Beverage Cost @ 25% $ 600.00 Revenue remaining after wages and beverage costs...