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
Aleks04 [339]
3 years ago
7

Problem 08-1A Preparing and analyzing a flexible budget LO P1, A1 [The following information applies to the questions displayed

below.] Phoenix Company’s 2019 master budget included the following fixed budget report. It is based on an expected production and sales volume of 15,000 units. PHOENIX COMPANY Fixed Budget Report For Year Ended December 31, 2019 Sales $ 3,150,000 Cost of goods sold Direct materials $ 945,000 Direct labor 225,000 Machinery repairs (variable cost) 45,000 Depreciation—Plant equipment (straight-line) 315,000 Utilities ($60,000 is variable) 180,000 Plant management salaries 200,000 1,910,000 Gross profit 1,240,000 Selling expenses Packaging 90,000 Shipping 105,000 Sales salary (fixed annual amount) 235,000 430,000 General and administrative expenses Advertising expense 150,000 Salaries 230,000 Entertainment expense 80,000 460,000 Income from operations $ 350,000 Problem 08-1A Part 1&2 Required: 1&2. Prepare flexible budgets for the company at sales volumes of 14,000 and 16,000 units and classify all items listed in the fixed budget as variable or fixed.

Business
1 answer:
cricket20 [7]3 years ago
4 0

Answer:

The answer is in the explanation

Explanation:

                                          Phoenix Company

                                          Fixed Budget Report  

                          For the 'fear Ended 31st December 2015  

                                                               Flexible Budget                    Flexible Budget for

                                             Variable Amount      Total Fixed       Unit Sales   Unit Sales

                                              per unit                     cost               of 14,000     of 16,000

Sales at 210 $ per unit (A)             210                                          2940000  3360000

                      Variable cost

Direct Material                             $ 62.00                                 $868,000.00  $ 992,000.00

Direct Labor                                  $ 14.00                                  $196,0000.00 $ 224,000.00

Machinery repairs                        $  3.00                                   $  42,000.00   $ 48,000.00

Utilities                                          $   2.00                                  $  28,000.00  $ 32,000.00

Packaging                                    $    6.00                                 $ 84,000.00    $ 96,000.00

Shipping                                       $    6.00                                 $ 84,000.00   $ 96,000.00

Total Variable Expenses (B)        $ 93.00                                 $1,302,000.00     $1,488,000.00

      Contribution margin (C=A-B)  $ 117.00                            $ 1,638,000.00 $ 1,872,000.00

      Fixed cost

Depreciation                                                    $ 315,000.00     $315,000.00   $ 315,000.00

Plant Management Salaries                           $ 210,000.00      $210,000.00  $ 210,000..

Utilities                                                             $ 180,000.00      $ 180,000.00 $ 180,000.00

Sales Salary                                                     $ 235,000.00      $ 235,000.00 $ 235,000.00

Advertising Expenses                                     $ 100,000.00      $ 100,000.00 $ 100,000.00  

Salaries                                                            $ 241,000.00      $ 241,000.00 $ 241,000.00

Entertainment Expenses                                $ 85,000.00       $ 85,000.00   $ 85,000.00

Total Fixed Expenses (D)                              $1,366,000.00   $1,366,000.00 $ I,366,000.00

                                                                        Net Profit (C-D)   $ 272,000.00 $ 506,000.00  

Variable Cost Per unit= Variable Cost / 150000  

                                Increase in Operating Income if Sales rise to 18000

                                                            Phoenix Company  

                                  Forecast contribution Margin Income Statement

                                          For the year Ended 31st December 2015  

Sales in Units                                                    15,000                  18,000

Contribution Margin Per Unit                    $           117            $          117

Contribution Margin                                   $ 1,755,000         $2,106,000

Fixed Costs                                                 $ 1,366,000         $ 1,366,000

Expected increase in Operating Income  $ 389,000           $ 740,000  

$ 351,000

                               Income (loss) from operation sale is reduced to 12000

                                                            Phoenix company  

                                  Forecast contribution Margin Income Statement

                                          For the year Ended 31st December 2015  

Sales in Units                                                    15,000                  12,000

Contribution Margin Per Unit                    $           117            $          117

Contribution Margin                                   $ 1,755,000         $1,404,000

Fixed Costs                                                 $ 1,366,000         $ 1,366,000

Operating Income                                     $ 389,000           $   38,000  

check the attached image for the correct arrangement of the tables and solution

You might be interested in
Qwik Service has over 200 auto-maintenance service outlets nationwide. It provides primarily two lines of service: oil changes a
Ann [662]

Answer:

A. The answer is:

Oil-related revenue = 0.75 x 40,000,000 = $30,000,000;

Repair-related revenue = 0.25 x 40,000,000 = $10,000,000

B. The answer is:

Oil-related revenue = 0.75 x 350,000 = $262,500;

Repair-related revenue = 0.25 x 350,000 = $87,500.

Explanation:

A.

Denote X is the total revenue Qwik Service has to earn.

We have:

Oil charge-related revenue: 0.75X; Oil charge-related margin 0.2 x 0.75X = 0.15X

Brake repair-related revenue: 0.25X; Brake repair-related margin: 0.25X x 0.6 = 0.15X.

=> Total contribution margin = 0.15X + 0.15X = 0.3X

To meet break-even, the total contribution margin should be equal to fixed cost or: 0.3X = 12,000,000 <=> X = $40,000,000

=> Oil-related revenue = 0.75 x 40,000,000 = $30,000,000;

    Repair-related revenue = 0.25 x 40,000,000 = $10,000,000.

B.

The note Y is the total revenue per one outlet.

At one outlet, revenue and margin will be:

Oil charge-related revenue: 0.75X; Oil charge-related margin 0.2 x 0.75X = 0.15X

Brake repair-related revenue: 0.25X; Brake repair-related margin: 0.25X x 0.6 = 0.15X.

=> Total contribution margin = 0.15X + 0.15X = 0.3X

To meet net income target of $45,000, the total contribution margin should be equal to fixed cost of $60,000 and delivering $45,000 net income or: 0.3X = 45,000 + 60,000 <=> X = $350,000.

=> Oil-related revenue = 0.75 x 350,000 = $262,500;

    Repair-related revenue = 0.25 x 350,000 = $87,500.

6 0
3 years ago
You're the account manager for a client who wants to increase reservations at her boutique hotel. You've been manually managing
Bumek [7]

Answer:<u><em> Apply target cost-per-acquisition (CPA) bidding to drive conversions at her desired CPA.</em></u>

Explanation: In this case the customer wants to gain administrative division at her  hotel, looking for ways to save time and optimize. We can most efficaciously do this by utilizing target cost-per-acquisition (CPA) bidding in order to thrust interpretation at her desired CPA.

<u><em>Therefore the correct option in this case is (d)</em></u>

3 0
3 years ago
Culver Corporation purchased machinery on January 1, 2022, at a cost of $288,000. The estimated useful life of the machinery is
Katarina [22]

Answer:

Please Kindly check the attach picture, the full working is there.

Explanation:

6 0
3 years ago
Brad has purchased a new boat for $20,000. He paid $3,000 as down payment and he paid the balance by a loan from his hometown ba
Pachacha [2.7K]
  • Monthly payment = $753.45
  • Interest in first month = $85

First remove the amount paid as down payment:

= 20,000 - 3,000

= $17,000

The amount to be paid monthly is a constant amount which would make it an Annuity.

The $17,000 is the present value of this Annuity so the formula for present value of annuity can be used to find the annuity.

The payment is monthly so the rate and number of periods needs to be converted:

Rate = 6%/12 = 0.5%

Period = 2 x 12 = 24 months

Annuity is:

<em>Present value of Annuity = Annuity x ( 1 - (1 + rate) ^- number of periods) / rate </em>

17,000 = A x ( 1 - ( 1 + 0.5%)⁻²⁴) / 0.5%

17,000 = A x 22.5628662

A = 17,000 / 22.5628662

A = $753.45

The interest in the first month is:

<em>= Interest rate x Amount borrowed </em>

= 0.5% x 17,000

= $85

In conclusion, the monthly payments will be $753.45 and the interest in the first month will be $85.

<em />

<em>Find out more at brainly.com/question/20691724.</em>

6 0
2 years ago
Nancy Appleton obtained a $45,000 loan for her start-up business. The SBA guaranteed 75% of the loan. How much has the bank risk
erma4kov [3.2K]

Based on the percentage that SBA guaranteed out of Nancy's loan, the bank stands to lose $11,250.

<h3>How much does the bank stand to lose?</h3>

The bank stands to lose the amount that wasn't guaranteed by the SBA in the event that Nancy Appleton's business fails.

This amount can be found as:

= Loan amount x ( 1 - percentage guaranteed)

Solving gives:

= 45,000 x ( 1 - 75%)

= $11,250

Find out more on loan guarantees at brainly.com/question/9636559.

3 0
2 years ago
Other questions:
  • Jim holds a commercial lease. Last year his rent went up 4% based on a 4% increase in the wholesale price index. What type of le
    9·1 answer
  • The traditional view is that the optimum level of inspection is where the
    5·1 answer
  • Ginormous Oil entered into an agreement to purchase all of the outstanding shares of Slick Company for $60 per share. The number
    8·1 answer
  • You have been pricing an MP3 player in several stores. Three stores have the identical price of $300. Each store charges 24 perc
    13·1 answer
  • What are the two types of state budgets?
    8·1 answer
  • Although you may know William Shakespeare from his classic literature, what is not well-known if that he was an astute investor.
    8·1 answer
  • Any factor that can change
    11·1 answer
  • Greg Downs recently has noticed that the plant he is managing is delivering only 30 percent of its products on time. To determin
    11·1 answer
  • "Girls Just Wanna Have Funds" is a Washington, DC, support group that consists mostly of young women who offer tips on budgeting
    11·1 answer
  • Johan was a newly hired attorney for Crontel Manufacturing, Inc. Even though he reported directly to the president of the compan
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!