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
laila [671]
2 years ago
8

Brighton, Inc., manufactures kitchen tiles. The company recently expanded, and the controller believes that it will need to borr

ow cash to continue operations. It began negotiating for a one-month bank loan of $600,000 starting May 1. The bank would charge interest at the rate of 1.25 percent per month and require the company to repay interest and principal on May 31. In considering the loan, the bank requested a projected income statement and cash budget for May.The following information is available:• The company budgeted sales at 600,000 units per month in April, June, and July and at 500,000 units in May. The selling price is $4 per unit.• The inventory of finished goods on April 1 was 120,000 units. The finished goods inventory at the end of each month equals 20 percent of sales anticipated for the following month. There is no work in process.• The inventory of raw materials on April 1 was 58,000 pounds. At the end of each month, the raw materials inventory equals no less than 40 percent of production requirements for the following month. The company purchases materials in quantities of 64,500 pounds per shipment.• Selling expenses are 10 percent of gross sales. Administrative expenses, which include depreciation of $2,000 per month on office furniture and fixtures, total $155,000 per month.• The manufacturing budget for tiles, based on normal production of 500,000 units per month, follows: Materials (0.25 pound per tile, 125,000 pounds, $4 per pound) $ 500,000 Labor 390,000 Variable overhead 180,000 Fixed overhead (includes depreciation of $200,000) 390,000 Total $ 1,460,000Required:(a) Prepare schedules computing inventory budgets by months for(1) Production in units for April, May, and June. (2) Raw materials purchases in pounds for April and May.(b) Prepare a projected income statement for May. Cost of goods sold should equal the variable manufacturing cost per unit times the number of units sold plus the total fixed manufacturing cost budgeted for the period. When calculating net sales assume cash discounts of 1% and bad debt expense of 0.50%.
Business
1 answer:
Igoryamba2 years ago
4 0

Answer:

Brighton, Inc.

a) Schedules Computing Inventory Budgets by months

a1) for Production:

                                          April           May          June       Total

Beginning Inventory     120,000    100,000      120,000        120,000

Units Produced            500,000   500,000     500,000     1,500,000

Inventory available      620,000   600,000     620,000     1,620,000

Less Ending Inventory 100,000    120,000      120,000        120,000

Units sold                    520,000    480,000     500,000    1,500,000

a2) Raw Materials Purchases in pounds

                                                   April           May

Ending inventory                    50,000        50,000

Raw materials required        125,000       125,000

Raw materials available        175,000       175,000

Beginning Inventory              58,000        50,000

Purchases                            117,000        125,000

Purchases value $4 per pound $468,000    $500,000

b) Projected Income Statement for May:

Net Sales                                                          $1,970,000

Cost of goods sold:

Finished Beginning Inventory $480,000

Cost of production                   1,460,000

less closing inventory                480,000       $1,460,000

Gross profit                                                        $510,000

Selling expenses                    $200,000

Administrative expenses          155,000         $355,000

Net Income                                                      $155,000

Explanation:

a)    Sales =                             $2,000,000

less cash discounts (1%)            ($20,000)

less bad debts expense (0.5%) ($10,000)

Net Sales =                             $1,970,000

c) Sales Budget

                         April           May            June             July              Total

Sales units   600,000     500,000      600,000       600,000       2,300,000

Sales value$2,400,000 $2,000,000 $2,400,000 $2,400,000$9,200,000

d) Cost of Production:

                                                      May  

Cost of raw materials used   $500,000

Labor                                        390,000

Variable overhead                    180,000

Fixed overhead                       390,000

Total                                    $1,460,000

e) Budgets are financial tools to forecast an entity's projections for sales, production, expenses, and cash balances.  They help to anticipate developments ahead of time in order to plan for them and to prepare for unanticipated occurrences.

You might be interested in
Brickhouse is expected to pay a dividend of $3.00 and $2.40 over the next two years, respectively. After that, the company is ex
Damm [24]

Answer:

$31.9211

Explanation:

We discount the future two year dividends at the required rate of return

and solve for the present value of the infinite series of dividends growing at 3.6% with the dividend grow model:

\frac{D_1}{r-g} =PV

\frac{2.4 (1.036)}{0.11-0.036} = PV

PV 33.6

Then we discount this by the two years ahead of time these cashflow start and add them to get the PV of the stock which is their intrinsic market value

\left[\begin{array}{ccc}Year&cashflow&PV\\&&\\1&3&2.7027\\2&2.4&1.9479\\2&33.6&27.2705\\&TOTAL&31.9211\\\end{array}\right]

6 0
3 years ago
1. Inventory that consists of the costs of the direct and indirect materials that have not yet entered the manufacturing process
Luba_88 [7]

Answer:

materials inventory

Explanation:

An inventory is a term used to describe a list of finished goods, goods still in the production line and raw materials that would be used for the manufacturing of more goods in a bid to meet the unending consumer demands.

Basically, an inventory can be classified into three (3) main categories and these are; finished goods, work in progress, and raw materials.

An inventory is recorded as a current asset on the balance sheet because it's primarily the most important source of revenue for a business entity.

Generally, the three (3) main cost concept associated with an inventory include;

1. First In First Out (FIFO).

2. Last In First Out (LIFO).

3. Weighted average cost.

In Financial accounting, direct cost can be defined as any expense which can easily be connected to a specific cost object such as a department, project or product. Some examples of direct costs are cost of raw materials, machineries or equipments.

On the other hand, any cost associated with the running, operations and maintenance of a company refers to indirect costs. Some examples of indirect costs are utility bill, office accessories, diesel etc.

Materials inventory can be defined as an inventory that comprises of direct and indirect materials costs which have not been used in a manufacturing process.

6 0
2 years ago
Bill Dukes has $100,000 invested in a 2-stock portfolio. $32,500 is invested in Stock X and the remainder is invested in Stock Y
pshichka [43]

Answer:

0.98

Explanation:

Computation for Bill Duke portfolio's beta

First step is to find the Investment in Y which is:

Investment in Y=100,000-35,000

=$65,000

Second step is to calculate for the Portfolio beta using this formula

Portfolio beta=Respective beta*Respective Investment weight

Portfolio beta =(35,000/100,000*1.5)+(65,000/100,000*0.7)

Portfolio beta=(0.35*1.5) +(0.65*0.7)

Portfolio beta =0.525 +0.455

Portfolio beta=0.98

Therefore the Portfolio Beta will be 0.98

7 0
3 years ago
Sherry is functionally blind and seems uninterested during class demonstrations or teacher-directed activities. what can you do
kow [346]
You could provide large print or braille materials for her.
3 0
3 years ago
If 20,000 worker-hours produced a total output of $600,000 in an economy, then the labor productivity is
cupoosta [38]

Answer:20 per hours Explanation:

6 0
3 years ago
Other questions:
  • If a company increases its sales price per unit for product​ a
    11·1 answer
  • For each "point" you pay on a mortgage, you get a one-quarter percent reduction in the interest rate. You want to get a .375% re
    14·2 answers
  • Healthy Foods Inc. sells 60-pound bags of grapes to the military for $15 a bag. The fixed costs of this operation are $90,000, w
    12·1 answer
  • The two major forms of employee involvement are participative management and ________. 1. job sharing 2. job rotation 3. represe
    13·1 answer
  • Which of the following statements is correct?
    12·1 answer
  • Your department store receipt says that you pay a 5% sales tax on sports equipment. this sales tax is an example of a
    8·1 answer
  • Dyl Inc.'s bonds currently sell for $1,040 and have a par value of $1,000. They pay a $65 annual coupon and have a 15-year matur
    14·1 answer
  • The process of dividing the potential market into sub-markets with common needs and features is called:________
    9·1 answer
  • Planning an annual budget is an important requirement for A. being financially sound.
    12·1 answer
  • Overnight trucking recently purchased a new truck costing $150,800. The firm financed this purchase at 8. 6 percent interest wit
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!