1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Talja [164]
3 years ago
9

Suppose a small business has sales of $14,000 this month, with future sales expected to grow by $1,300 each month. Costs consist

of a fixed component, which is $8,400 per month, and a variable component, which is 25 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 8 months from now?
Business
1 answer:
jeyben [28]3 years ago
8 0

Answer:

Please check the attachment to this document to get the excel sheet

Gross Profit (8 months from now)=$10,875

Explanation:

Please check the attachments of this post and download the excel sheet.

Best of luck

Download xlsx
You might be interested in
Which amendment to the U.S. Constitution provides the protection of due process of law and protection from having to testify aga
Vedmedyk [2.9K]

the 5th amendment i believe

3 0
3 years ago
Ratio of 10% and assuming that banks keep no excess reserves, imagine that $300 is deposited into a checking account. by how muc
ludmilkaskok [199]
<span>If the ratio of 10% and assuming that banks keep no excess reserves, imagine that $300 is deposited into a checking account, then $ 1,287 is the amount for the money supply to increase if the fed lowers the required reserve ratio to 7%.</span>
4 0
3 years ago
Peg and Al Fundy have a limited food budget, so Peg is trying to feed the family as cheaply as possible. However, she still want
Inga [223]

Answer:

A) we requiere to fulfill the Vitamint contrains or surpass them A => 12 C=>6

B) we request that instead of fullfilling the vitaming requirement to be 12/6 or more

to be exactly for this amount.

Explanation:

We set up the situation in excel Solver with the following constraing:

     1        2      3      4

A    3 3 1 7

B    3 1 1 1

C        12 6 24

C2 = A1*A2 + B1*B2

C3 = A1*A3 + B1*B3

C4 = A1*A4 + B1*B4

common constraing:

C4 min

A1 = integer

B1 = integer

A) constraing

C2 => 12

C3 =>6

B) contraing to achieve the exact value for each vitamin:

C2 = 12

C3 =  6

4 0
3 years ago
The product life cycle defines the stages that new products move through as they enter, are established in, and ultimately leave
notsponge [240]

Answer:

Market Attribute – Introduction stage - Low sales

Market Attribute – Growth stage - Opportunities increase

Market Attribute – Maturity stage - Intense competition

Market Attribute – Decline stage - Niche segment  

Consumer Types – Introduction stage - Sylvie

Consumer Types – Maturity stage - Winnie

Consumer Types – Decline stage - Francine

6 0
3 years ago
Cougar Plastics Company has been operating for three years. At December 31 of last year, the accounting records reflected the fo
Nikitich [7]

Answer:

a. Purchased short-term investments for $8,600 cash.

Dr short term investments 8,600

    Cr cash 8,600

b. Lent $6,300 to a supplier who signed a two-year note.

Dr notes receivable 6,300

    Cr cash 6,300

c. Purchased equipment that cost $24,000; paid $4,900 cash and signed a one-year note for the balance.

Dr equipment 24,000

    Cr cash 4,900

    Cr notes payable 19,100

d. Hired a new president at the end of the year.

no entry

e. The contract was for $86,000 per year plus options to purchase company stock at a set price based on company performance.

no entry

f. Issued an additional 2,300 shares of $0.50 par value common stock for $19,000 cash.

Dr cash 19,000

    Cr common stock 115

    Cr additional paid in capital 18,885

g. Borrowed $19,000 cash from a local bank, payable in three months.

Dr cash 19,000

    Cr notes payable 19,000

h. Purchased a patent (an intangible asset) for $1,100 cash.

Dr patent 1,100

    Cr cash 1,100

i. Built an addition to the factory for $29,000; paid $8,700 in cash and signed a three-year note for the balance.

Dr building 29,000

    Cr cash 8,700

    Cr notes payable 20,300

j. Returned defective equipment to the manufacturer, receiving a cash refund of $2,400.

Dr cash 2,400

    Cr equipment 2,400

<h2>Cougar Plastics Company</h2><h2>Balance Sheet</h2><h2>For the year ended December 31, 202x</h2><h2>Assets</h2>

<u>Current assets:</u>

Cash $33,800

Accounts receivable $4,600

Inventory $27,000

Investments (short-term) $10,700

Total current assets                               $76,100

<u>Long term investments:</u>

Notes receivable $9,000

Total long term investments                  $9,000

<u>Property, plant and equipment:</u>

Equipment $78,600

Factory building $120,000

Total P, P & E                                      $198,600

<u>Intangible assets:</u>

Intangibles $4,500

Patent $1,100

Total intangible assets                    <u>     $5,600</u>

Total assets                                                                             $289,300

<h2>Liabilities and stockholders' equity</h2>

<u>Current liabilities:</u>

Accounts payable $19,000

Accrued liabilities payable $3,100

Notes payable (short-term) $43,300

Total current liabilities                       $65,400

<u>Long term liabilities:</u>

Notes payable $61,300

Total long term liabilities                   $61,300

<u>Stockholders' equity:</u>

Common stock $10,815

Additional paid-in capital $115,185

Retained earnings $36,600

Total stockholders' equity              <u>$162,600</u>

Total liabilities + stockholder's equity                                     $289,300

7 0
4 years ago
Other questions:
  • A marketing manager has discovered that relevant, internal secondary data don't exist to support a decision process. The next st
    14·1 answer
  • Janice works as a consultant for a tech company. In the past, the company has relied heavily on its toll-free line to sell new p
    6·2 answers
  • Cost behavior ______. categorizes costs as fixed, mixed and variable is a detailed analysis technique used to determine whether
    11·1 answer
  • Vision Tech’s stock price is currently trading at $17 per share. The consensus among analysts is that the intrinsic value of Vis
    5·1 answer
  • The gizmo industry has the following characteristics: over 600 producers with no one producer furnishing more than .5% of the in
    13·1 answer
  • Assume that you have been hired by a large international bank that is looking to develop a smartphone app to help college studen
    10·1 answer
  • Please answer need help asap
    10·1 answer
  • Alex is working on reconciling the balance sheet for his company. He is using a _____, which will ensure that the plan for next
    6·1 answer
  • in the theory of percect competition the assumption of easy entry into and exit from the market implies
    8·1 answer
  • A shipment that is transported using two or more modes during its journey is said to be?
    6·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!