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
mars1129 [50]
3 years ago
6

This week we looked at inventory analysis. The ABC analysis is used to help determine critical inventory and replenishment rates

. This week we are going to use Excel to build an ABC analysis and create a cycle counting program to determine replenishment rates.
The steps for the assignment are below.
Perform an ABC analysis for a kitchen of an upscale restaurant in Excel (use food items for this analysis).
If you can't get that data, do it for your own kitchen at home. Create a cycle counting program for it.
Business
1 answer:
kozerog [31]3 years ago
6 0
I I bivivibvibibbvhihihvivg
You might be interested in
Xion Co. budgets a selling price of $80 per unit, variable costs of $35 per unit, and total fixed costs of $271,000. During June
natka813 [3]

Answer:

Income 219,500 256,000 36,500 Favourable

Explanation:

Flexible Budget report showing variances between budgeted and actual results.

Flexible Actual Variance

Sales 872,000 894,000 22,000 Favourable

Variable expenses 381,500 352,000 29,500 Unfavorable

Contribution margin 490,500 542,000 51,500 Favourable

Fixed expenses 271,000 286,000 15000 Unfavorable

Income 219,500 256,000 36,500 Favourable

Sales $80×$10,900=$872,000

Variable $35×$10,900=$381,500

7 0
3 years ago
Refer back to the original information. Blake has decided to add stadium blankets to his product line. He has found a supplier w
Sonja [21]

Answer:

Blake must sell 80 blankets  and 320 stuffed mascots in order to break even.

Explanation:

The question is incomplete, the accounts are missing, so I looked for them:

February March

Sales revenue $25,000 $37,500

Cost of goods sold 10,000 15,000

Gross profit 15,000 22,500

Rent expense 1,500 1,500

Wages expense 3,500 5,000

Shipping expense 1,100 1,650

Utilities expense 750 750

Advertising expense 1,000 1,400

Insurance expense 585 585

Operating income $6,565 $11,615

The income statement using the contribution margin format would be as follows:

Income Statement              Year 1                  Year 2

Sales revenue                   $25,000            $37,500

Variable costs:

  • Cost of goods sold   $10,000            $15,000
  • Wages expense*        $3,000             $4,500
  • Shipping expense       $1,100              $1,650
  • Advertising expense*   $800              $1,200

Contribution margin           $10,100            $15,150

Period costs:

  • Wages expense*           $500               $500
  • Advertising expense*   $200               $200
  • Rent expense              $1,500            $1,500
  • Insurance expense       $585               $585
  • Utilities expense           $750               $750

Net income                         $6,565             $11,615

*high low cost method for wages expense and advertisement expense:

variable wages expense = ($5,000 - $3,500) / (3,000 - 2,000) = $1.50 per unit

fixed wages expense = $5,000 - (3,000 x $1.50) = $500

variable advertising expense = ($1,400 - $1,000) / (3,000 - 2,000) = $0.40 per unit

fixed advertising expense = $1,400 - (3,000 x $0.40) = $200

contribution margin per stuffed mascot = $15,150 / 3,000 = $5.05 per unit

contribution margin per blanket = $60 - ($32 + $1.50 + $0.55 + $0.40) = $25.55

sales ratio 1 blanket : 4 mascots

weighted contribution margin = ($25.55 x 20%) + ($5.05 x 80%) = $5.11 + $4.04 = $9.15

total fixed costs = $3,535 + $125 = $3,660

break even number in units = $3,660 / $9.15 = 400 units

Blake must sell 80 blankets  and 320 stuffed mascots in order to break even.

4 0
3 years ago
The ________ function calculates the periodic interest for a specified payment period on a loan or investment.
djyliett [7]

The NPER(Number of Periods) function calculates the periodic interest for a specified payment period on a loan or investment.
So the correct filling is NPER(Number of Periods)

What is NPER
NPER stands for the number of loan payment intervals. As a result, it is a financial word. Excel has a built-in financial feature that we may use to calculate the NPER value of any loan. For the rate, finished payment, current value, and future value, this formula permits user input. We can access this formula via the "Formulas" tab or the keyboard shortcut =NPER().

To learn more about NPER
brainly.com/question/25879801
#SPJ4

4 0
2 years ago
Ensuring the availability of products in the right place in the right quantities at the right time in a cost efficient manner is
lidiya [134]

Answer:

C. Physical distribution.

Explanation:

Physical distribution: It is one of important activity of supply chain, it is included in every step of production, right from supply of raw material to the delivery of finished goods to the customer. Logistic remain a key industry in the economy and physical distribution of product are important for customer satisfaction and maintaining the customer expected services. In physical distribution, it is very important that right goods are delivered to right customer at right time and in right place.

5 0
3 years ago
A property is purchased for $200,000 with an 80 percent LTV. After five years, the owner’s equity is $80,000. What would be the
krok68 [10]

Answer:

The answer is 14.9%

Explanation:

Purchase price = $200,000

Loan-to-value(LTV) = 80%

Number of years = 5 years

Owner's equity = $80,000.

Loan amount = purchase price x LTV

=$200,000 x 80%

=$160,000.

Annual expected appreciation rate on home equity =

(Loan÷equity)^-n

$160,000/$80,000^-5

=14.9%

Therefore, Annual expected appreciation rate on home equity is 14.9%

6 0
3 years ago
Other questions:
  • A focused differentiator has the advantage of: A. being able to respond to demands for deep price discounts. B. producing a larg
    8·1 answer
  • The APB partnership agreement specifies that partnership net income be allocated as follows:
    13·1 answer
  • On January 1, year 1, Mark Corp. purchases equipment for $300,000. The equipment has a 10-year life and a $50,000 residual value
    5·1 answer
  • Suppose the interest on a foreign government bonds is 7.5%, and the current exchange rate is $0.03571/foreign currency (i.e. 28
    14·1 answer
  • Lego is considering an investment in Disney corporation. The risk free rate is 5% and the Beta for Disney is 1.2. Lego requires
    12·2 answers
  • Steel mill wage costs increase by 18 percent over a year. What is the likely economic effect on the market for steel?
    5·1 answer
  • After Kira had had several drinks one night, she sold Charlotte a diamond necklace worth thousands of dollars for just $100. The
    6·1 answer
  • The Machining Department supervisor has been very pleased with this performance because actual expenditures for January–March ha
    8·1 answer
  • Help! Select the qualification that is best demonstrated in each example.
    15·2 answers
  • On April 1, Townsley Company sold merchandise with a selling price of $10,000 on account to Trout Company, with terms 3/10, n/30
    6·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!