Questions
Storm Tools has formed a new business unit to produce battery-powered drills. The business unit was...

Storm Tools has formed a new business unit to produce battery-powered drills. The business unit was formed by the transfer of selected assets and obligations from the parent company. The unit's initial balance sheet on January 1 contained cash ($500,000), plant and equipment ($2,500,000), notes payable to the parent ($1,000,000), and Common Stock ($2,000,000). The business unit is expected to repay the note at $50,000 per month, plus all accrued interest at 1/2% per month. Payments are made on the last day of each month. The unit is scheduled to produce 25,000 drills during January, with an increase of 2,500 units per month for the next three months. Each drill requires $40 of raw materials. Raw materials are purchased on account, and paid in the month following the month of purchase. The plant manager has established a goal to end each month with raw materials on hand, sufficient to meet 25% of the following month's planned production. The unit expects to sell 20,000 drills in January; 25,000 in February, 25,000 in March, and 30,000 per month thereafter. The selling price is $100 per drill. Half of the drills will be sold for cash through a website. The others will be sold to retailers on account, who pay 40% in the month of purchase, and 60% in the following month. Uncollectible accounts are not material. Each drill requires 20 minutes of direct labor to assemble. Labor rates are $24 per hour. Variable factory overhead is applied at $9 per direct labor hour. The fixed factory overhead is $25,000 per month; 60% of this amount is related to depreciation of plant and equipment. With the exception of depreciation, all overhead is funded as incurred. Selling, general, and administrative costs are funded in cash as incurred, and consist of fixed components (salaries, $100,000; office, $40,000; and advertising, $75,000) and variable components (15% of sales).

Prepare the master budget for the quarter ended March 31, 2018.

Can an expert help prepare the master budget with the template below

STORM TOOLS
SALES BUDGET
QUARTER ENDED MARCH 31, 2018
JANUARY FEBRUARY MARCH QUARTER
Unit sales            20,000              25,000                25,000              70,000
Unit sales price                 100                   100                     100                   100
Budgeted sales revenue $ 2,000,000 $    2,500,000 $      2,500,000

$    7,000,000

SERGEY CORPORATION
PRODUCTION BUDGET
QUARTER ENDED MARCH 31, 2018
JANUARY FEBRUARY MARCH QUARTER
Unit sales         20,000             25,000       25,000        70,000
Desired ending inventory           5,000               7,500       12,500        12,500
Total needed         25,000             32,500       37,500        82,500
Beginning inventory                  -                 5,000          7,500                 -  
Units to be produced         25,000             27,500       30,000        82,500
QUARTER ENDED MARCH 31, 2018
JANUARY FEBRUARY MARCH QUARTER
Units to be produced                25,000         27,500         30,000         82,500
Desired ending inventory             6,875.00            7,500           8,125           8,125
Total needed $            31,875 $     35,000 $     38,125 $     90,625
Less: Beginning inventory                         -              6,875           7,500                  -  
Direct Materials to purchase                31,875         28,125         30,625         90,625
Cost of materials per unit                        40                 40                 40                 40
Cost of purchases $            31,915 $     28,165 $     30,665 $     90,665
SERGEY CORPORATION
DIRECT LABOR BUDGET
QUARTER ENDED MARCH 31, 2018
JANUARY FEBRUARY MARCH QUARTER
Direct labor hours             0.33              0.33              0.33             0.33
Labor rate per hour $       24.00 $       24.00 $       24.00 $       24.00
Direct labor cost per unit $         8.00 $          8.00 $         8.00 $         8.00
Units to be produced         25,000          27,500         30,000         82,500
Direct labor cost $ 200,000 $   220,000 $   240,000 $ 660,000
SERGEY CORPORATION
MANUFACTURING OVERHEAD BUDGET
QUARTER ENDED MARCH 31, 2018
JANUARY FEBRUARY MARCH QUARTER
Direct Labor Hours
X Variable Factory Overhead Rate $            9.00 $           9.00 $           9.00 $           9.00
Total variable overhead
Fixed Costs
Total overhead
Less: Depreciation
Cash payments for overhead
Estimated overhead rate: $           3.91
SELLING, GENERAL AND ADMINISTRATIVE EXPENSES BUDGET
QUARTER ENDED MARCH 31, 2018
JANUARY FEBRUARY MARCH QUARTER
Estimated Sales ($)
X Variable SG&A rate 15% 15% 15% 15%
Total variable selling, general and administrative expenses
Fixed costs:
Salaries
Office
Advertising
Total fixed selling & administrative expenses
Total S & A expenses
SERGEY CORPORATION
BUDGETED INCOME STATEMENT
QUARTER ENDED MARCH 31, 2018
JANUARY FEBRUARY MARCH QUARTER
Sales
Less: Cost of Goods Sold
Gross Margin
Less: S&A Expenses
           Interest Expense             5,000            4,750             4,500           14,250
Net Income
Cost Per Unit
Direct Materials
Direct Labor
Factory Overhead
Total Cost per unit
SERGEY CORPORATION
CAPITAL EXPENSES BUDGET
QUARTER ENDED MARCH 31, 2018
JANUARY FEBRUARY MARCH QUARTER
Capital Expenses $                -   $              -   $               -   $                -  
STORM TOOLS
CASH RECEIPTS AND DISBURSEMENTS BUDGET
QUARTER ENDED MARCH 31, 2018
JANUARY FEBRUARY MARCH QUARTER
Cash receipts:
Collection of credit sales:
January
February
March
Total cash receipts
Cash disbursements:
Purchases of materials:
January
February
March
Total disbursements for purchases
Payment of direct labor
Payment of overhead
Payment of S & A expenses
Capital acquisition
Financing:
Planned repayment
Interest on note (1/2% of unpaid balance)
Total cash disbursements
Excess or (deficiency)
Plus: Beginning cash balance
Ending cash balance
Sales:
Cash Sales 50%
Remaining 50% on credit with collections as follows
Month of Sale 40%
Month after sale 60%
Direct Material Payments
Month of Sale 0%
Month after sale 100%
SERGEY CORPORATION
BUDGETED BALANCE SHEET
MARCH 31, 2018
ASSETS LIABILITIES
Accounts Payable
Cash Notes Payable - Parent Company
Accounts Receivable
Inventories: Stockholders' Equity
Direct Materials
Finished Goods Common Stock
Equipment Retained Earnings
Less: Accum Depr Rounding Error (Should be less than $100)
Total Assets Total Liabilities and Stockholders' Equity

In: Accounting

The FIFO inventory method requires that a. the cost of the first items purchased be assigned...

The FIFO inventory method requires that a. the cost of the first items purchased be assigned to cost of goods sold. b. the cost of the last items purchased be assigned to cost of goods sold. c. the earliest goods purchased be allocated to ending inventory. d. the company uses a perpetual inventory system.

In: Accounting

Ezekiel Elliot (a professional football player) recently signed a contract that will pay him the following...

Ezekiel Elliot (a professional football player) recently signed a contract that will pay him the following amount (in millions)

Year Payment
2021 18
2022 11
2023 13
2024 10
2025 12

If the annual interest rate is 5%, what is the present value (in millions) of Elliot’s contract (consider 2020 as time 0)?

In: Finance

Grab a blank sheet of paper and try some inflation analysis on your own. Take a...

Grab a blank sheet of paper and try some inflation analysis on your own. Take a picture or scan your sheet, and upload it after you are finished. This contributes to your participation grade in the class.

  1. Because inflation increased by only 1.7% in 2008, the American Association of Retired Persons comments that this is “an unfortunate side effect of inflation, since Social Security payments, which are indexed to inflation, will increase by only 1.7% in 2008.” Comment on whether this is an “unfortunate side effect of inflation” or not.
  2. The Federal Reserve Bank (Fed) can impact the economy through changes in the Federal funds rate, because changes in this interest rate will change all interest rates throughout the economy. The Federal funds rate was constant at 5.25% from 1996–1998, a time of falling inflation. What impact did this have on real interest rates during this time? What was likely to happen to investment spending?
  3. “Traveling in Turkey is much cheaper now than it was 10 years ago,” says a friend. "Ten years ago, a dollar bought 1,000 lira; this year, a dollar buys 1,500 lira.” Total inflation over this period was 25% in the United States and 100% in Turkey. Is your friend right or wrong—has it become more or less expensive to travel in Turkey?

In: Economics

Diversified Inc. is a retailer that sells a variety of goods under three major business units....

Diversified Inc. is a retailer that sells a variety of goods under three major business units. Its Home Appliances Division manufactures and sells home kitchen appliances such as refrigerators, microwave ovens and dishwashers.During his annual review of the company’s financial condition, Diversified’s president notes that the company’s inventory included a material reduction described as an allowance to reduce inventory to market. While the Home Appliances Division had received a considerable amount of negative publicity related to fires caused by defective switches in its products, the president felt that any reduction in the market value of these products that was taken in the third quarter was more than offset by the high margins the High Fashion Division. Therefore, the president felt that no write down should have been taken. Further, the president notes that the company had replaced the faulty switches in the third fiscal quarter and subsequent sales had shown that the market value of its appliances had partially recovered. All estimates are that the value of the appliance inventory should be completed recovered by the fourth quarter of the next fiscal year.Research the related generally accepted accounting principles and prepare a short memo to the accounting file not to exceed two pages that addresses the president’s concerns. Cite your references and applicable paragraph numbers.

In: Accounting

Data shows graduate program admission decisions (Yes: 1 and No: 2), GRE score and undergraduate GPA...

Data shows graduate program admission decisions (Yes: 1 and No: 2), GRE score and undergraduate GPA for twenty-five students.

Tasks:

Examine if the given data is suitable for the application of linear discriminant analysis.

Create a linear discriminant function predicting admission decisions.

Comment on the classification accuracy.

Predict the admission decision given GRE score = 690 and GPA = 3.2.

Perform logistic regression analysis for the data.

Compare the classification accuracies of both methods.

Admit GRE GPA
2 790 3.8
1 370 3.4
2 480 2.9
1 580 3.3
1 620 3.9
1 740 3.2
2 490 3.1
2 720 3.7
1 740 3.9
2 460 3.4
1 610 3.3
1 260 2.5
2 740 4
1 700 3.6
1 760 3.5
1 410 2.8
1 700 4
1 800 3.4
2 680 2.9
2 520 3.2
1 700 3.5
1 580 3.3
2 470 3.9
1 640 3.8
2 410 3.8

In: Statistics and Probability

Use Minitab Data shows graduate program admission decisions (Yes: 1 and No: 2), GRE score and...

Use Minitab

Data shows graduate program admission decisions (Yes: 1 and No: 2), GRE score and undergraduate GPA for twenty-five students.

Tasks:

Examine if the given data is suitable for the application of linear discriminant analysis.

Create a linear discriminant function predicting admission decisions.

Comment on the classification accuracy.

Predict the admission decision given GRE score = 690 and GPA = 3.2.

Perform logistic regression analysis for the data.

Compare the classification accuracies of both methods.

Admit GRE GPA
2 790 3.8
1 370 3.4
2 480 2.9
1 580 3.3
1 620 3.9
1 740 3.2
2 490 3.1
2 720 3.7
1 740 3.9
2 460 3.4
1 610 3.3
1 260 2.5
2 740 4
1 700 3.6
1 760 3.5
1 410 2.8
1 700 4
1 800 3.4
2 680 2.9
2 520 3.2
1 700 3.5
1 580 3.3
2 470 3.9
1 640 3.8
2 410 3.8

In: Statistics and Probability

The manager of a computer retails store is concerned that his suppliers have been giving him...

The manager of a computer retails store is concerned that his suppliers have been giving him laptop computers with lower than average quality. His research shows that replacement times for the model laptop of concern are normally distributed with a mean of 4 years and a standard deviation of 0.4 years. He then randomly selects records on 49 laptops sold in the past and finds that the mean replacement time is 3.8 years.

Assuming that the laptop replacement times have a mean of 4 years and a standard deviation of 0.4 years, find the probability that 49 randomly selected laptops will have a mean replacement time of 3.8 years or less.
P(M < 3.8 years) =  
Enter your answer as a number accurate to 4 decimal places. NOTE: Answers obtained using exact z-scores or z-scores rounded to 3 decimal places are accepted.

Based on the result above, does it appear that the computer store has been given laptops of lower than average quality?

  • Yes. The probability of this data is unlikely to have occurred by chance alone.
  • No. The probability of obtaining this data is high enough to have been a chance occurrence.

In: Statistics and Probability

Weldon Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data regarding the store's...

Weldon Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data regarding the store's operations follow:

  • The company sells each unit for $45.

Budgeted Sales:

Month

October

November

December

January

Sales in Units

30,000

25,000

40,000

30,000

  • Collections are expected to be 70% in the month of sale, 30% in the month following the sale.
  • The A/R balance at September 30th will be collected in full in October.
  • The cost of the merchandise is $38 per unit.
  • In addition to meeting the current month’s sales demand, management wants to maintain and ending inventory balance of 10% of the next month’s sales.
  • The beginning inventory balance at October 1st is 3,000 units.
  • Payment for merchandise is made as follows: ½ paid in the month of the purchase, ½ paid the month following the purchase.
  • The A/P balance at September 30th will be paid in full in October.
  • A dividend was paid in October for $500,000.
  • Minimum cash balance is $100,000.
  • The company has a line of credit for $500,000 at an annual interest rate of 12%.
  • Loans are taken out on first day of month borrowed and repaid at the end of the quarter with interest.

           

Balance Sheet

September 30

Assets

Cash.........................................................................................

$   100,000

Accounts receivable................................................................

250,000

Inventory.................................................................................

114,000

Property, plant and equipment
(net of $200,000 accumulated depreciation).......................

866,400

Total assets..............................................................................

$1,330,400

Liabilities and Stockholders’ Equity

Accounts payable....................................................................

$   300,000

Common stock.........................................................................

582,000

Retained earnings....................................................................

     448,400

Total liabilities and stockholders’ equity................................

$1,330,400

            Required:

  1. Prepare a Sales Budget for October, November, December, and Quarter.
  2. Prepare a Schedule of Expected Cash Collections for October, November, December, and Quarter.
  3. Prepare a Merchandise Purchases Budget for October, November, December, and Quarter.
  4. Prepare a Schedule of Expected Cash Disbursements for October, November, December, and Quarter.
  5. Prepare Cash Budgets for October, November, December, and Quarter.

In: Accounting

Calculating the Cash Budget Wiggles, Inc., has estimated sales (in millions) for the next four quarters...

  1. Calculating the Cash Budget Wiggles, Inc., has estimated sales (in millions) for the next four quarters as follows: (40 ptos)

Q1

Q2

Q3

Q4

Sales

$105

$90

$122

$140

Sales for the first quarter of the year after this one are projected at $120 million. Accounts receivable at the beginning of the year were $34 million. Wiggles, has a 45-day collection period.

Wiggle’s purchases from suppliers in a quarter are equal to 45 percent of the next quarter’s forecast sales, and suppliers are normally paid in 36 days. Wages, taxes, and other expenses run about 30 percent of sales. Interest and dividends are $6 million per quarter.

Wiggles plans a major capital outlay in the second quarter of $40 million. Finally, the company started the year with a $32 million cash balance and wishes to maintain a $15 million minimum balance.

Complete a cash budget for Wiggles by filling in the following:

WIGGLES, INC. Cash Budget ($ in millions)

Q1

Q2

Q3

Q4

Target cash balance

$15

Net cash inflow

Ending cash balance

Minimum cash balance

15

Cumulative surplus (deficit)

Assume that Wiggles can borrow any needed funds on a short-term basis at a rate of 3 percent per quarter, and can invest any excess funds in short-term marketable securities at a rate of 2 percent per quarter. Prepare a short-term financial plan by filling in the following schedule. What is the net cash cost (total interest paid minus total investment income earned) for the year?

WIGGLES, INC. Short-Term Financial Plan ($ in millions)

Q1

Q2

Q3

Q4

Target cash balance

$15

Net cash inflow

New short-term investments

Income from short-term investments

please present the calculations

In: Finance