Suppose a small business has sales of $12,000 this month, with future sales expected to grow...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Suppose a small business has sales of $12,000 this month, with future sales expected to grow by $1,500 each month. Costs consist of a fixed component, which is $6,000 per month, and a variable component, which is 30 percent of sales. Design a spreadsheet to compute the gross profit (revenue less fixed and variable costs) per month over a nine month period. What is the gross profit in a single month 5 months from now? Suppose a small business has sales of $12,000 this month, with future sales expected to grow by $1,500 each month. Costs consist of a fixed component, which is $6,000 per month, and a variable component, which is 30 percent of sales. Design a spreadsheet to compute the gross profit (revenue less fixed and variable costs) per month over a nine month period. What is the gross profit in a single month 5 months from now?
Expert Answer:
Answer rating: 100% (QA)
Month 1 2 3 4 5 10 6 7 8 9 Sales 12000 13500 15000 16500 18000 19500 21000 22500 24000 Fixed Costs ... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Suppose that a small business has close ties to one country, such as Iran, through family relationships. Isnt it unfair that the U.S. government embargoes that one country, making it impossible for...
-
A retail business has sales of 100,000 cost of goods sold of 35,000 salaries of 15,000 rental of 4,000 and advertising of 8,000. All of the income and expenses have been paid out of the owners...
-
A small business has weekly costs of C = 100 + 30x + x2/10 where x is the number of units produced each week. The competitive market price for this business's product is $46 per unit. Find the...
-
Middleton Spas provides the following data for the year just ended on December 31. Requirement Prepare the operating activities section of Middleton Spas' statement of cash flows for the year just...
-
During 2000, a corporation spent $170,000 in research and development costs. As a result, a new product was patented. The patent was obtained on October 1, 2000, and had a legal life of 20 years and...
-
Describe what sorts of ligands are needed to produce metalorganic frameworks (MOFs).
-
Explain how depreciation generates actual cash flows for a firm.
-
Johnson Co. accepts a note receivable from a customer in exchange for some damaged inventory. The note requires the customer make semiannual installments of $50,000 each for 10 years. The first...
-
Duncan's Diamond Bit Drilling Corporation (Duncan) purchased the following assets in 2023. Assume its taxable income was $60,000 for purposes of computing the 179 expense deduction. Asset Purchase...
-
The horizontal x-axis is drawn through the centroid C of the area shown, and it divides the area into two component areas A1 and A2. Determine the first moment of each component area with respect to...
-
Calculate the power delivered to each resistor in the circuit shown in the figure below. (Let R1 = 3.00 2, R2 = 2.00 N, and V = 12.0 V.) resistor R1 7.40 4.00-ohm resistor 9.86 resistor R2 2.19 X W...
-
If the covenant of quiet enjoyment is breached, the tenant can sue the landlord for damages. (True/False)
-
Nationwide Companys chief financial officer resigns. After a personnel search, an investigation, and an interview, the board of directors hires Anton. Anton turns out to be dishonest. Nationwides...
-
Unless a partnership agreement specifies otherwise, profits are shared in the same ratio as capital contributions. (True/False)
-
General Retail Associates (GRA) owned Valley Mall. Reliable Property Management Company operated the mall on GRAs behalf. Reliable leased the storefronts to tenants, including GameOn, and contracted...
-
What does the warranty of habitability require a landlord to do?
-
How to measure the variables? (construct) & What is a sampling of this search? Abstract: Social media is the gathering place of a large pool of consumers. It serves as an archive for consumer...
-
Assume Eq. 6-14 gives the drag force on a pilot plus ejection seat just after they are ejected from a plane traveling horizontally at 1300 km/h. Assume also that the mass of the seat is equal to the...
-
a. A firm generated $143 million in free cash flow and paid a net dividend of $49 million to shareholders. How much was paid to debt holders and debt issuers? b. A firm paid a dividend to...
-
If an investor wants to buy a stock with high earnings growth but with how risk, she must pay a high multiple of earnings for it. Correct?
-
Telesoft Corp. traded at a price-to-book ratio of 0.98 in May 1999 after reporting an ROCE of 52.2 percent. Does the market regard this ROCE as normal, unusually high, or unusually low?
-
What role does the HAL play in the platform?
-
If your logic analyzer is capable of on-the-fly disassembly, use it to display bus activity in the form of instructions, rather than simply 1s and 0s.
-
Draw UML state diagrams for device 1 and device 2 in a four-cycle handshake.
Study smarter with the SolutionInn App