Rochester Street Taco Shop (RSTS) sells a variety of tacos to go all at a price of
Question:
Rochester Street Taco Shop (RSTS) sells a variety of tacos to go all at a price of $4.50 each. The variable cost of an RSTS taco averages $2.40. RSTS incurs monthly fixed costs of $7,350. RSTS is subject to a 20 percent tax rate.
Required
Using the Goal Seek function in Microsoft Excel, how many tacos must RSTS sell to earn a monthly operating profit after taxes of $6,720?
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 70% (10 reviews)
The following two screenshots show the setup and solution Notice the profit formula in the fo...View the full answer
Answered By
Bhartendu Goyal
Professional, Experienced, and Expert tutor who will provide speedy and to-the-point solutions. I have been teaching students for 5 years now in different subjects and it's truly been one of the most rewarding experiences of my life. I have also done one-to-one tutoring with 100+ students and help them achieve great subject knowledge. I have expertise in computer subjects like C++, C, Java, and Python programming and other computer Science related fields. Many of my student's parents message me that your lessons improved their children's grades and this is the best only thing you want as a tea...
3.00+
2+ Reviews
10+ Question Solved
Related Book For
Question Posted:
Students also viewed these Business questions
-
Pampa Parts produces a single product, the NF-9. The product has a unit variable cost of $70 and annual fixed costs of $343,200. Pampa is subject to a 20 percent tax rate. Required Suppose the NF-9...
-
Refer to the data for Pampa Parts in Exercise 3-44. Required Suppose Pampa expects to sell 8,150 units of NF-9 next year, but the price is uncertain. Using the Goal Seek function in Microsoft Excel,...
-
Izzy Ice Cream has the following price and cost iformation Price per 2-scoop sundae Variable cost per sundae: Ingredients S 5.80 1.35 Direct labor Dverhead Fixed cost per month a.45 0.20 $8,400...
-
Suppose that a 12-inch ruler must have the correct length L to within 0.0002 inch. (a) Write an absolute value inequality for L that describes this requirement. (b) Solve this inequality and...
-
From an investor's standpoint, why are actively managed mutual funds likely to be tax inefficient?
-
A grocery store uses a fixed order cycle policy for ordering the paper towels it sells to the stores customers. Demand for the paper towels is normally distributed with a mean of 50 rolls per day and...
-
Mrs. Clarks Foods was an Iowa company engaged in the business of distributing juice beverages. International Suntrade and Miller & Smith Foods were Canadian companies that acted as brokers...
-
The Quality Desk Company makes two types of computer desks from laminated particle board. The Presidential model requires 30 square feet of particle board, 1 keyboard sliding mechanism, and 5 hours...
-
The adjusted trial balance for Chiara Company as of December 31 follows. Cash Accounts receivable Interest receivable Debit $ 30,000 Credit 52,000 18,000 nt ok Notes receivable (due in 90 days)...
-
A solid circular bar ABCD with fixed supports is acted upon by torques T0 and 2T0 at the locations shown in the figure. Obtain a formula for the maximum angle of twist (max of the bar. (Use Eqs. 3-46...
-
Explain the purpose of the statement of cash flows and why this statement is needed.
-
Annchester Car Service offers limousine service to the local airport. The cost of a trip (one-way) is $95 and the variable costs of a trip are $42, which covers fuel, variable car maintenance, labor,...
-
Elgart Company produces plastic mailboxes. The projected income statement for the coming year follows: Sales ...............$460,300 Total variable cost ......... 165,708 Contribution margin...
-
calculate the double declining balance depreciation and book values for an asset costing 8 0 , 0 0 0 . 0 0 with a salvage value of 1 0 , 0 0 0 . 0 0 that will be depreciated over 1 0 years.
-
2. Jessica witnessed a car accident in which a person was seriously injured, and she is going to testify at the trial of the drunk driver who caused the accident. Define each of the following...
-
Explain the process of using mutual funds to implement an investment plan once an asset allocation has been completed using a mean variance optimization model and a risk tolerance tool for the...
-
Suman company has the following inventory, purchases and sales data for August Inventory Inventory on 0 1 - Aug 1 0 0 units @ 5 Purchased on 0 5 - Aug 6 0 0 units @ 6 Purchased 1 1 - Aug 3 0 0 units...
-
2. Jason is the sole shareholder of a corporation called "Shell Corp." In the two years since Jason incorporated Shell Corp, the business has never held a board of directors meeting, or even...
-
Let A be an m n matrix with linearly independent columns. Explain why ATA must be an invertible matrix. Must AAT also be invertible? Explain.
-
Which of the companies has the lowest accounts receivable turnover in the year 20X2? a. Company A. b. Company B. c. Company C. d. CompanyD. 20X1 20X2 Credit Sales Average Receivables Balance $1.0...
-
What do the terms variable costs and fixed costs mean?
-
Materials and labor are always direct costs, and supply costs are always indirect. What is your opinion of this statement?
-
Materials and labor are always direct costs, and supply costs are always indirect. What is your opinion of this statement?
-
Keith deposited $5,000 in a bank account he established for a pet store that he is going to own and operate. The money was obtained by a bank loan taken by Keith. What effect will the recording of...
-
A taxpayer files their return and pays the IRS $2,500 for their taxes due. Upon examination, the IRS determines that the taxpayer understated their liability and they actually owed $3,500. They...
-
3 With 20/20 hindsight (pun intended), we know that most century bond issuers from 2010 to 2019, including Penn, did not get the "deal of the century" by selling bonds when they did. What sequence of...
Study smarter with the SolutionInn App