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 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 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 picture or scan your sheet, and upload it after you are finished. This contributes to your participation grade in the class.
In: Economics
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 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 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 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?
In: Statistics and Probability
Weldon Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data regarding the store's operations follow:
Budgeted Sales:
|
Month |
October |
November |
December |
January |
|
Sales in Units |
30,000 |
25,000 |
40,000 |
30,000 |
|
Balance Sheet |
||
|
September 30 |
||
|
Assets |
||
|
Cash......................................................................................... |
$ 100,000 |
|
|
Accounts receivable................................................................ |
250,000 |
|
|
Inventory................................................................................. |
114,000 |
|
|
Property, plant and equipment |
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:
In: Accounting
|
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