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 residual equity ($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 a monthly comprehensive budget plan for Storm's new business unit for January through March. The plan should include the (a) sales and cash collections budget, (b) production budget, (c) direct materials purchases and payments budget, (d) direct labor budget, (e) factory overhead budget, (f) ending finished goods budget (assume total factory overhead is applied to production at the rate of $11.73 per direct labor hour), (g) SG&A budget, and (h) cash budget.
STORM TOOLS
Sales Budget
For the Three Months January to March
January February March
Expected Cash Collections From Sales
STORM TOOLS
Production Budget
For the Three Months January to March
January February March
STORM TOOLS
Direct Materials Budget
For the Three Months January to March
January February March
Expected Cash Payments for Materials Purchases
STORM TOOLS
Direct Labor Budget
For the Three Months January to March
January February March
STORM TOOLS
Factory Overhead Budget
For the Three Months January to March
January February March
STORM TOOLS
Ending Finished Goods Inventory
31-Mar
Units Per Unit Cost Per Unit Total
STORM TOOLS
Selling, General, and Administrative Budget
For the Three Months January to March
January February March
STORM TOOLS
Cash Budget
For the Three Months January to March
January February March
Beginning cash balance
Plus: Customer receipts
Available cash
Less disbursements:
Direct materials
Direct labor
Factory overhead
SG&A
Total disbursements
Cash surplus/(deficit)
Financing:
Planned repayment
Interest on note (1/2% of unpaid balance)
Ending cash balance

Answers

Answer 1

Answer:

Storm Tools

STORM TOOLS

1. Sales Budget

For the Three Months January to March

                                                        January     February      March

Expected Cash Collections

 From Sales                                 $1,400,000  $2,275,000   $2,500,000

STORM TOOLS

2. Production Budget

For the Three Months January to March

                                             January         February           March

Production Schedule            25,000            27,500          30,000      

Cost of direct materials $1,000,000      $1,100,000   $1,200,000

STORM TOOLS

4. Direct Materials Budget

For the Three Months January to March

                                             January         February           March

Expected Cash Payments

for Materials Purchases                          $1,025,000   $1,125,000

STORM TOOLS

5. Direct Labor Budget

For the Three Months January to March

                                     January         February           March

Direct labor costs       $200,000     $220,000      $240,000

STORM TOOLS

6. Factory Overhead Budget

For the Three Months January to March

                                             January         February           March

Variable overhead       $75,000    $82,500       $90,000     $97,500

Fixed overhead             25,000       25,000         25,000       25,000

Total overhead          $100,000   $107,500       $115,000   $122,500

Depreciation cost          15,000        15,000          15,000        15,000

Cash payment for o/h $85,000   $92,500      $100,000   $107,500

STORM TOOLS

7. Ending Finished Goods Inventory

31-Mar

                       Units Per Unit     Cost Per Unit      Total

January               5,000               $51.91             $259,550

February             7,500               $51.91             $389,325

March                12,500               $51.91             $648,875

STORM TOOLS

Selling, General, and Administrative Budget

For the Three Months January to March

                                                     January         February         March

Fixed overhead:

Salaries                                       $100,000       $100,000       $100,000

Office expenses                            40,000           40,000           40,000

Advertising                                    75,000           75,000            75,000

Fixed overhead                         $215,000       $215,000          $215,00

Variable overhead                      210,000          341,250         375,000

Selling, General, and Admin.  $425,000      $556,250      $590,000

STORM TOOLS

Cash Budget

For the Three Months January to March

                                             January         February           March

Beginning cash balance   $500,000     $1,135,000       $1,461,500

Plus: Customer receipts   1,400,000      2,275,000       2,500,000

Available cash                $1,900,000     $3,410,000      $3,961,500

Less disbursements:

Direct materials                     $0           $1,025,000      $1,125,000

Direct labor                        200,000         220,000          240,000

Factory overhead                85,000            92,500          100,000  

SG&A                                  425,000         556,250         590,000

Total disbursements        $710,000     $1,893,750    $2,055,000

Cash surplus/(deficit)    $1,190,000     $1,516,250     $1,906,500

Financing:

Planned repayment         $50,000          $50,000        $50,000

Interest on note

(1/2% of unpaid balance)    5,000               4,750             4,500

Ending cash balance   $1,135,000      $1,461,500    $1,852,000

Explanation:

a) Data and Calculations:

Initial Balance Sheet on January 1:

Cash $500,000

Plant and equipment $2,500,000

Total assets $3,000,000

Notes payable $1,000,000

Residual equity $2,000,000

Total liabilities and equity $3,000,000

Repayment of note:

Note payment $50,000 per month

Accrued interest     250

Total repayment $50,250 per month

                                     January         February         March           April

Production Schedule   25,000            27,500         30,000        32,500

Cost of direct materials $1,000,000  $1,100,000   $1,200,000  $1,300,000

Ending raw materials        6,875          7,500             8,125

Production Schedule     25,000        27,500          30,000        32,500

Beginning raw materials 6,250           6,875            7,500           8,125

Purchase of materials   25,625         28,125         30,625

Cost price = $40 per drill

Payment for materials                     $1,025,000   $1,125,000    $1,225,000

Beginning Finished goods                   5,000           7,500        12,500

Production                    25,000          27,500         30,000        32,500

Ending Finished goods  5,000            7,500          12,500        15,000

Sales                             20,000         25,000         25,000        30,000

Selling price = $100 per drill

Credit sales:                $1,000,000  $1,250,000   $1,250,000  $1,500,000

40% month of sale          400,000      625,000        625,000       750,000

60% following month                           400,000        625,000      625,000

Cash sales                    1,000,000    1,250,000      1,250,000    1,500,000

Total sales collection $1,400,000 $2,275,000   $2,500,000 $2,875,000

Direct labor per drill = 20 minutes

Labor rates = $24 per hour

Variable overhead = $9 per direct labor hour

Production Schedule     25,000        27,500          30,000        32,500

Total labor hours              8,333           9,167           10,000         10,833

Direct labor costs       $200,000    $220,000   $240,000     $260,000

Variable overhead       $75,000    $82,500       $90,000     $97,500

Fixed overhead             25,000       25,000         25,000       25,000

Total overhead          $100,000   $107,500       $115,000   $122,500

Depreciation cost          15,000        15,000          15,000        15,000

Cash payment for o/h $85,000   $92,500      $100,000   $107,500

Selling, general, and administrative costs:

Fixed overhead        $215,000   $215,000      $215,000   $215,000

Variable overhead     210,000      341,250        375,000     431,250

Total selling, etc     $425,000   $556,250     $590,000 $628,250

Cost of production:

Cost of direct materials $1,000,000  $1,100,000   $1,200,000  $1,300,000

Direct labor costs            $200,000    $220,000     $240,000    $260,000

Overhead applied                97,746        107,529         117,300         127,071

Total costs of prodn.     $1,297,746  $1,427,529   $1,557,300    $1,687,071

Production Schedule          25,000         27,500         30,000          32,500

Cost per unit                   $51.91               $51.91         $51.91           $51.91


Related Questions

Smith and Sons, Inc. Income Statement (in millions)

2016 2015
Net sales 10,300 9,800
Cost of goods sold (5,500) (5,200)
Gross profit 4,800 4,600
Selling and administrative expenses (2,800) (2,700)
Income from operations 2,000 1,900
Interest expense (300) (250)
Income before income taxes 1,700 1,650
Income tax expense (420) (400)
Net income 1,280 1,250

Smith and Sons, Inc. Balance Sheet

Assets
Current assets
Cash and cash equivalents 450 650
Accounts receivable 900 800
Inventory 750 900
Other current assets 400 250
Total current assets 2,500 2,600
Property, plant & equipment, net 2,350 2,250
Other assets 5,700 5,900
Total Assets 10,550 10,750

Liabilities and Stockholders' Equity
Current liabilities 3,250 3,150
Long-term liabilities 5,000 5,400
Total liabilities 8,250 8,550
Stockholders' equity-common 2,300 2,200
Total Liabilities and Stockholders' Equity 10,550 10,750

Required:
Calculate the quick ratio for Smith & Sons, Inc., for 2015 and 2016.

Answers

Answer:

2015 Quick Ratio 0.54

2016 Quick Ratio 0.54

Explanation:

Calculation to determine the quick ratio for Smith & Sons, Inc., for 2015 and 2016

Using this formula

Quick Ratio = Quick assets/Current liabilities

Let plug in the formula

2015 Quick Ratio = (2,600-900)/3150

2015 Quick Ratio= 0.54

2016 Quick Ratio = (2500-750)/3,250

2016 Quick Ratio = 0.54

Therefore the quick ratio for Smith & Sons, Inc., for 2015 is 0.54 and 2016 is 0.54

Park Co.'s wholly-owned subsidiary, Schnell Corp., maintains its accounting records in German marks. Because all of Schnell's branch offices are in Switzerland, its functional currency is the Swiss franc. Remeasurement of Schnell's 20X1 financial statements resulted in a $7,600 gain, and translation of its financial statements resulted in an $8,100 gain. What amount should Park report as a foreign exchange gain in its income statement for the year ended December 31, 20X1

Answers

Answer: $7600

Explanation:

The amount that Park should report as a foreign exchange gain in its income statement for the year ended December 31, 20X1 will be $7600.

We should note that when we want to determine the net income for a particular period, the translatation adjustments will not be included. Therefore the $8100 gain won't be included in the calculation. Hence, Park should report only $7600 gain.

Patterson Development sometimes sells property on an installment basis. In those cases, Patterson reports income in its income statement in the year of the sale but reports installment income by the installment method on the tax return. Installment income in 2021 was $240 million, which Patterson expects to collect equally over the next four years. The tax rate is 25%, but based on an enacted law, is scheduled to become 35% in 2023.
Patterson's pretax accounting income for the 2013 income statement was $530 million of this, $30 million is non-taxable revenue from proceeds of a life insurance policy. There were no differences between accounting income and taxable income other than those described above and no cumlative temporary differences existed at the beggining of the year:
1. Prepare the appropriate journal entry to record patterson's 2013 income taxes.
2. What is Patterson's 2013 net income?

Answers

Answer:

1. Debit Income tax expense for $143 million; Credit Deferred tax liability for $78 million; and Credit Income tax payable for $65 million.

2. Patterson's 2021 net income is $387.

Explanation:

Note: There is an error in the question because of date inconsistency. Therefore, 2021 upward is used in the answer to ensure date consistency.

1. Prepare the appropriate journal entry to record patterson's 2021 income taxes.

Note: See the attached excel file for the calculation of income tax payable and deferred tax liability.

The journal entry will look as follows:

Date                General journal                    Debit ($'M)         Credit ($'M)  

31 Dec 2021    Income tax expense                143

                          Deferred tax liability                                           78

                          Income tax payable                                            65

                        (To record income tax payable.)                                          

2. What is Patterson's 2021 net income?

This can be determined as follows:

Particulars                                    ($'Million)    

Pre accounting income                      530

Income tax expense                         (143)    

Net income                                         387  

how can a writer be grief when writing professional letters



A. By adding a writer be brief when writing professional letters


B. By adding background information


C. By avoiding words that end in " Ize or ton"


D. By writing a concise letters that addresses your purpose

Answers

The correct answer is D

Answer:

D. By writing a concise letters that addresses your purpose

Explanation:

Got it right.

Determining Amounts to be Paid on Invoices Determine the amount to be paid in full settlement of each of the following invoices, assuming that credit for returns and allowances was received prior to payment and that all invoices were paid within the discount period. Merchandise Freight Paid by Seller Terms Returns and Allowances a. $14,200 - FOB shipping point, 1/10, n/30 $700 b. 10,700 $400 FOB shipping point, 2/10, n/30 1,300 c. 5,700 - FOB destination, 1/10, n/30 500 d. 3,800 200 FOB shipping point, 2/10, n/30 500 e. 1,500 - FOB destination, 2/10, n/30 -

Answers

Answer:

a. Amounts to be Paid on Invoice = $12,150

b. Amounts to be Paid on Invoice = $7,920

c. Amounts to be Paid on Invoice = $4,680

d. Amounts to be Paid on Invoice = $2,840

e. Amounts to be Paid on Invoice = $1,200

Explanation:

a. $14,200 - FOB shipping point, 1/10, n/30 $700

Amounts to be Paid on Invoice = ($14,200 - $700) * (10/10 - 1/10) = $12,150

b. 10,700 $400 FOB shipping point, 2/10, n/30 1,300

Amounts to be Paid on Invoice = (($10,700 - $1,300) * (10/10 - 2/10)) + $400 = $7,920

c. 5,700 - FOB destination, 1/10, n/30 500

Amounts to be Paid on Invoice = ($5,700 - $500) * (10/10 - 1/10) = $4,680

d. 3,800 200 FOB shipping point, 2/10, n/30 500

Amounts to be Paid on Invoice = (($3,800 - $500) * (10/10 - 2/10)) + $200 = $2,840

e. 1,500 - FOB destination, 2/10, n/30 -

Amounts to be Paid on Invoice = $1,500 * (10/10 - 2/10) = $1,200

Crane Sporting Goods expects to have earnings per share of $6 in the coming year. Rather than reinvest these earnings and grow, the firm plans to pay out all of its earnings as a dividend. With these expectations of no growth, Crane's current share price is $60 and the cost of equity capital is 10%. Suppose Crane could cut its divident payout rate to 75% for the foreseeable future and use the retained earnings to open new stores. The return on investment in these stores is expected to be 12%. if we assume that the risk of these new investments is the same as the risk of its existing investments, then the firm's equity cost of capital is unchanged. What effect would this new policy have on Crane's stock price

Answers

Answer:

Stock price increases

Explanation:

We need to determine the stock price with the new policy

Stock price can be determined using the constant growth dividend model

according to the constant dividend growth model

price = d1 / (r - g)

d1 = next dividend to be paid

r = cost of equity

g = growth rate

growth rate = retention rate x Return on investment

Retention rate = 1 - payout ratio = 1 - 0.75 = 0.25

growth rate = 0.25 x 12 = 3%

Stock price = 6/(0.10 - 0.03) = $85.71

Under the new policy, stock price increases

Old Economy Traders opened an account to short-sell 1,300 shares of Internet Dreams at $46 per share. The initial margin requirement was 50%. (The margin account pays no interest.) A year later, the price of Internet Dreams has risen from $46 to $59, and the stock has paid a dividend of $3.50 per share. a. What is the remaining margin in the account? (Round your answer to the nearest whole dollar.)

Answers

Answer: $8450

Explanation:

First, we need to calculate the total initial asset which will be the value of shares sold and the margin which will be:

= (1300 × $46) + (50% × 1300 × $46)

= $59800 + $29900

= $89700

We will then calculate total liability which will be:

= (1300 × $59) + (1300 × $3.50)

= $76700 + $4550

= $81250

The remaining margin will then be:

= $89700 - $81250

= $8450

Other Questions
Describe the difference between a flask, beaker, and graduated cylinder. How does the purpose of each differ? Qu plato de El mundo hispano debe elegir una persona vegetariana? What is the momentum of a 200 kg truck travelling at 20 m/s? PLEASE HELP!!!This graph shows the relationship between demand and price for goods sold at a shop. Anna plots the data on a scatter plot and draws a line of best fit to represent the relationship as shown. This is not the line of best fit because the line ____________.A.) Is close to the data pointsB.) does not fit every data point exactly.C.) Is not through the middle of the data points.Anna could get a better fit by _____ A.) Decreasing B.) IncreasingC.) Keepingthe y-intercept and ______ the slope.A.) Decreasing B.) IncreasingC.) Keeping Which process will create a figure that is congruent to the figure shown? The quotient of a number and -6 decreased by 2, is 10. FInd the number The outsider book * please answer* IF YOU READED BEFORE.What Does Two-Bit do with the empty soda bottle? *Cracks it to make a weapon.Takes it home for his DIY project.Puts it in the recycling bin.Drinks the rest of the soda out of it. Help please!!!! Ill appreciate it so much! can you help me please Which of the following choices correctly completes this sentence? Chandra's _____ papers on India's struggle for independence focus on imperialism affecting ______ native Indians. A. two/six-hundred-twenty-five-million B. 2/625,000,000 C. 2/six-hundred-twenty-five-million D. two/625,000,000 How did 9/11 effect domestic policy? Sal is tiling his entryway. The floor plan is drawn on a unit grid. Each unit length represents 1 foot. Tile costs $2.15 per square foot. How much will Sal pay to tile his entryway? Round your answer to the nearest cent. What is the missing length? No links please! Giving out Brainliest too. :) blank plus 1/5 equals to 1/2 A form of behavior therapy that is generally done in three steps as a way to reduce fear and anxiety is referred to as _________.A.aversion therapyB.systematic desensitizationC.cognitive therapyD.rational-emotive behavior therapy 31. Which sequence shows increasing ecologicallevels of organization?A. organism, population, community, ecosystemB. ecosystem, population, organism, communityC. community, ecosystem, population, organismD. population, organism, ecosystem, community Josea went out to dinner at an Indian restaurant. Thetotal bill was $38. She wanted to leave a 15% tip.If you use the idea of scaling to find the tip amount,what would she need to multiply by? Determining Amounts to be Paid on Invoices Determine the amount to be paid in full settlement of each of the following invoices, assuming that credit for returns and allowances was received prior to payment and that all invoices were paid within the discount period. Merchandise Freight Paid by Seller Terms Returns and Allowances a. $14,200 - FOB shipping point, 1/10, n/30 $700 b. 10,700 $400 FOB shipping point, 2/10, n/30 1,300 c. 5,700 - FOB destination, 1/10, n/30 500 d. 3,800 200 FOB shipping point, 2/10, n/30 500 e. 1,500 - FOB destination, 2/10, n/30 - The midpoint AB is M (1,1). If the coordinates of A are (-3,-3), what are the coordinates of B how can a writer be grief when writing professional lettersA. By adding a writer be brief when writing professional letters B. By adding background information C. By avoiding words that end in " Ize or ton"D. By writing a concise letters that addresses your purpose