Prepare monthly comprehensive budget plan

Assignment Help Financial Accounting
Reference no: EM13906886

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.

Reference no: EM13906886

Questions Cloud

Determines that merchandise inventory on hand : Juan Morales Company had the following account balances at year-end: Cost of Goods Sold $62,850; Inventory $16,850; Operating Expenses $33,020; Sales Revenue $118,730; Sales Discounts $1,140; and Sales Returns and Allowances $1,700. A physical count ..
Identify the types of aggression that occur in the category : Identify the types of aggression that occur in the category, as well as the age range of targets and perpetrators, the setting or context in which most types of the aggression occur, the severity of the category of aggression, and the frequency wi..
Prepare separate entries for each transaction on the books : On June 10, Tuzun Company purchased $6,950 of merchandise from Epps Company, FOB shipping point, terms 1/10, n/30. Tuzun pays the freight costs of $460 on June 11. Damaged goods totaling $450 are returned to Epps for credit on June 12. Prepare separa..
Round interest payments to the nearest wholedollar : Karim Corp. requires a minimum $8,000 cash balance.
Prepare monthly comprehensive budget plan : 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. Prepare a monthly comprehensive budget plan for Storm's new busines..
Investigate the unified modeling language : Investigate the Unified Modeling Language (UML) on the Internet. Briefly describe the development of the latest UML diagrams. Explain how UML differs from the older ways of writing programs in the past. List down the advantages and disadvantages o..
Identify associated stereotypes and discriminatory behaviors : Brief explanation of one current (20th or 21st century) example of prejudice and identify associated stereotypes and discriminatory behaviors
How is technology such as iphone impacting business world : How is technology such as the iPhone impacting the business world and changing consumer decisions when purchasing goods and services?
Controller of optus communications : Maureen Shelley is controller of Optus Communications. Optus manufactures cell phones. She has prepared a list of typical costs incurred by the business. Review the list and determine whether each cost is a product cost or period cost. For product co..

Reviews

Write a Review

Financial Accounting Questions & Answers

  Find the effect on the net operating income

If the Bath Department is dropped, find the effect on the net operating income of the company as a whole? (Input the amount as positive value. Omit the "$" sign in your response.

  Management issues affected by instability of social security

As a benefits manager, how might the potential demise of Social Security affect the decisions you make regarding other benefits that you have the option of providing to your employees? How might it affect your company's human resource planning proces..

  Evaluate the effect on the basis of the condominium

Evaluate the total amount of deductions for and from AGI that Kim can take during the present year with respect to the condominium and evaluate the effect on the basis of the condominium?

  Manufacturing firm that uses job-order costing

Alam Company is a manufacturing firm that uses job-order costing. At the beginning of the year, the company's inventory balances were as follows: Prepare the appropriate journal entry for each of the items above (a. through j.). You can assume that a..

  Prepare journal entries for the investments in sas

On August 31, 2010, a company purchased 10,000 shares of stock for $30 per share. Management recorded the stock in the securities available for the sale portfolio. The following information pertains to the price per share of stock.

  Illustrate what is her basis in her interest in jkl

What is her basis in her interest in JKL on January 1? How much income from JKL does she report on her personal 2010 return? Illustrate what is her basis in her interest in JKL on December 31, 2010?

  The shelter association of gogebic county gets the majority

the shelter association of gogebic county gets the majority of its funding from the local chapter of the united way.

  Hawks ltd

On 1 July 2011, Hawks Ltd acquired land for $1 500 000 and machinery for $ 1 000 000. Hawks Ltd uses cost model to account land and revaluation model to account for machinery. Hawks Ltd depreciated the machinery over its useful life of four years, us..

  Calculate free cash flows for common equity shareholders

Beginning with cash flows from operating activities, calculate free cash flows for common equity shareholders for Dick's Sporting Goods for fiscal years ending in 2009, 2008, and 2007.

  What point will the inventory be transferred

Why do you think that this amount is not shown in a separate inventory account? In which of the accounts shown is the inventory likely to be? At what point will the inventory be transferred to a separate inventory account?

  How are general long-term liabilities distinguished

How are general long-term liabilities distinguished from other long-term liabilities of the government? How does the financial reporting of general long-term liabilities differ from the financial reporting of other long-term liabilities?

  Prepare the four basic financial statements

The following information for the nine months ended September 30, 2013 was reported by OpenTable, Inc. Prepare the four basic financial statements for 2013.

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