Create monthly comprehensive budget plan for storm

Assignment Help Managerial Accounting
Reference no: EM132762125

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).

Problem 1: Make 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.

Reference no: EM132762125

Questions Cloud

Prepare journal entries to record transaction for crane co : Crane Company, Prepare the journal entries to record the transactions described. Crane Company purchased 70 Rinehart Company 6%, 10-year, $1,180 bonds
Explain the importance of a transport policy : Regulation of transportation, Explain the importance of a transport policy, citing at least five points with relevant examples to illustrate your explanation.
Development in the various modes of transportation : The Hub and Spoke Concept continues its development in the various modes of transportation (Maritime, Air, Truck, and Rail).
Internet field trip : Internet Field Trip (complete) conduct (take) a personal "internet field trip"
Create monthly comprehensive budget plan for storm : Create monthly comprehensive budget plan for Storm's new business unit for January through March. The plan should include the sales and cash collections
Legal and ethical dilemma : Deciding to place a loved one into a long-term care facility can be extremely difficult.
How often the company needs to apply an impairment test : How often the company needs to apply an impairment test on its assets? The management also wants to know if any assets require annual impairment test?
Quality and performance in health care organization : Reliable data are needed for administrators to make the best decisions to improve quality and performance in a health care organization.
How much additional money will izzy need to put aside : Izzy estimates that it will cost $49,000, How much additional money will Izzy need to put aside herself annually for the next 5 years to pay for medical school?

Reviews

Write a Review

Managerial Accounting Questions & Answers

  The company has had superior financial performance

Assume that the cost of capital is 12 percent. Is it clear that the company has had superior financial performance?

  Perform a corporate capabilities analysis

Perform an external (industry and competition) analysis. What implications can be drawn for the launch of Hockey Classic?

  Determine what is the amount of current assets

Do you have more than one kind of inventory? For example, Raw Material, Goods in Process, Finished Goods. How many do they have of each class?

  How jay could use to improve the business

Provide a minimum of three variances that Jay could analyze to monitor the business and explain how Jay could use these to improve the business.

  How much is actually the direct labour cost

How much is actually the direct labour cost if the manufacturing overhead cost for the period is $49,000 and the direct materials cost is $20,000?

  Expertise in operational accounting services to our clients

BUSN9262 - Contribute to the Company budgeting process, monthly management reporting and annual statutory accounts.

  Operating leverage-margin of safety and cost behavior

What is the accounting concept to explain how a 3% decline in sales could cause a 21% decline in profits. Also, discuss the effect of declining sales on an organization's margin of safety.

  Journalize the merchandise transactions

Journalize the following merchandise transactions: Refunded $1,000 to customer for defective merchandise that was not returned

  Calculate four different cost-plus prices

Calculate four different cost-plus prices using four different cost bases which may help with the pricing decision for Dream Limited.

  Cost per equivalent unit for materials

The ending inventory was 80% complete with respect to materials and 20% complete with respect to conversion costs - cost per equivalent unit for materials for the month in the first processing department is closest to

  How do identify the parties potentially affected by audit

How do Identify the parties potentially affected by this audit and the fee plan proposed. Describe some ethical considerations guiding your recommendation.

  Denote the set of positive integers

In this assignment, N will denote the set of positive integers, Z the set of all integers, Q the set of all rational numbers, and R the set of all real numbers. After any problem statement, feel free to hit the Enter key as often as you need to ma..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd