Question

Hi! I believe I have solved most of the problem, but I need guidance when it comes to formating the information into an excel sheet in the 3rd request. Below, I gave the situation for this problem, as well as the request that this fictional company has. The Situation... As a new hire for GMC, you have been assigned to assist a new client -Smith Shirts-a start-up business which manufactures and sells various styles of shirts. We rent production equipment that costs us $350 a week The materials for producing one shirt costs $8.00 o We believe we can sell each finished shirt for $15 each Smith Shirts would like your feedback on the following tasks... 1. How many shirts must we sell in one week if we want to break even? 7x-350 15x-8x+350 15x-8x-350 By letting the revenue equal the cost, we get x-50 as the answer X-350/7 x-50 2. If we can average 20 shirts sold per week, what will our revenue be per week? Per year? 15(20)-8(20)+350 300 510 510/300 $210 a week $210 x 52 weeks-$10,920 a year 3. Please create an Excel chart showing our profits (per year) for all possible production levels between 0 and 200 shirts per week. This is the problem I am stuck on, any assistance you could provide would be much appreciated!

0 0
Add a comment Improve this question Transcribed image text
Know the answer?
Add Answer to:
Hi! I believe I have solved most of the problem, but I need guidance when it...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • i dont understand 13-15 can u explain? Precle and Problem Solving berdes Practice When eale expression...

    i dont understand 13-15 can u explain? Precle and Problem Solving berdes Practice When eale expression that models each word phrase 10. four more than a number 11. the product of 8 and the sum of a numbers and 3 12. the quotient of the difference between 5 and a number, and 2 Write an algebraic expression that models each situation. 13. Jenny had $130, but she is spending $10 per week 14. The piggy bank contained $25, and $1.50...

  • Each week a U.S. consumer may prepare home cooked meals (9) as well as eat out...

    Each week a U.S. consumer may prepare home cooked meals (9) as well as eat out at a restaurant (9). Suppose the average price of a home cooked meal is p. =15, the price of eating out is p, = 20, and average spending is $300 per week. The typical consumer picks q, and q2 to maximize utility function U = 7.subject to their budget. 5. Now consider an increase in an individual's budget (Y) relative to problem I while...

  • got the answers i just need the work shown to get them. here is the problem,...

    got the answers i just need the work shown to get them. here is the problem, the graph, and numbers 227- Preliminary Problem Add the following three forces geometrically, where F, - 300 F,- 400g and F, - 350 g. (Note that we are using mass as weight, since they are proportional Strictly speaking, we should change grams into Newton to represent forces) Use the paper provided to do this exercise F:- 400g 20 F1 - 300g F, = 350g...

  • Hi there, I have problem-solving this question, would definitely need help to explain if we need ...

    Hi there, I have problem-solving this question, would definitely need help to explain if we need to look for the taxable income portion: Question: Topless:- A sporty convertible with a cost of $100,000 and a useful life of 5 years. It will produce rental income of $60,000 per year and operating costs of $10,000 per year. A major service is required after 3 years costing $15,000. A salvage value of $25,000 is expected after 5 Years. The required return is...

  • Hi, here is the problem! i just need help with the ones i got wrong! thank...

    Hi, here is the problem! i just need help with the ones i got wrong! thank you! E3-4 (Static) Identifying Expenses LO3-2, 3-3 Revenues are normally recognized when a company transfers promised goods or services to customers in the amount the company expects to be entitled to receive. Expense recognition is guided by an attempt to match the costs associated with the generation of those revenues to the same time period. Assume that the following transactions occurred in January: McGraw-Hill...

  • I need help solving this problem. Thanks in advance. If correct, I will leave a like...

    I need help solving this problem. Thanks in advance. If correct, I will leave a like and a comment! Practice Problem 18.3 Constants Now let's look at the potential energy of a charge that is in the vicinity of two other charges. Suppose two electrons are held in place 10.0 cm apart. Point a is midway between the two electrons, and point b is 12.0 cm directly above point a. (a) Calculate the electric potential at point a and at...

  • i need help with this exce problem. i got everyrhing done but im stuck on G...

    i need help with this exce problem. i got everyrhing done but im stuck on G and im noy sure what to do. please if answer do it in excel. than k you Sue has opened a bakery specializing in Gun Oakery specializing in cupcakes. Herhude must account for fixed expenses, such as her facility lease, utilities, and credit card equipment fees. In addition, she acca costs including cost of goods sold and credit card processing fees. You will use...

  • i need help with 3-7 please. thanks! The requirements for this problem: 1. Record cach transaction...

    i need help with 3-7 please. thanks! The requirements for this problem: 1. Record cach transaction as a journal entry. 2. Post the transactions to T-accounts using the following chart of accounts. Cash Accounts Receivable Office Supplies Prepaid Insurance Truck Accumulated Deprec.- Truck Accounts Payable Salaries Payable Unearned Revenue Taylor, Capital Taylor, Withdrawals Income Summary Service Revenue Salaries Expense Rent Expense Deprec. Expense- Truck Insurance Expense Fuel Expense Off, Supplies Expense Advertising Expense 3. Prepare an unadjusted trial balance as...

  • I have Two Problems which are both solved below. My question is what makes the approach...

    I have Two Problems which are both solved below. My question is what makes the approach of solving in each one not the same. Why does one calculation include avoidable traceable cost while the other doesn't? 2nd Problem: (2400000)= segment margin lost 1800000=savings in traceable fix cost due to discontinuation of beta 765000=Additional contribution margin *West Region has Traceable costs that should be avoidable according to segment statement so again why for the Diego company problem, 250000 in avoidable Traceable...

  • Please show all steps with formulas. I have viewed other answers, however, I do not think...

    Please show all steps with formulas. I have viewed other answers, however, I do not think wage is a variable cost. Let me know what you think. I will up vote for good content - thank you! Case ON-THE-GO: Cost-Volume-Profit Analysis Peter Kankel, the CFO of On-the-Go convenience stores, had only a couple of hours to decide what he would recommend. Decisions to add products are often challenging. Kankel knows that modern convenience stores have to do more than just...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT