Question

In: Accounting

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 residual equity ($2,225,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.

Solutions

Expert Solution


Related Solutions

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 residual equity ($2,225,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...
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...
Makita Inc. manufactures a variety of battery-powered hand tools. The company has assembled the following data...
Makita Inc. manufactures a variety of battery-powered hand tools. The company has assembled the following data pertaining to its two most popular products: Drill Saw Direct Materials $60 110 Direct Labour 40 90 Manufacturing Overhead* 160 320 Cost if purchased from outside supplier 200 380 Annual Demand in units 200,000 220,000 * The manufacturing overhead is applied at a rate of $80 per machine hour used in production. Twenty five percent of the MOH is variable in nature and the...
Sam Inc. manufactures a variety of battery-powered hand tools. The company has assembled the following data...
Sam Inc. manufactures a variety of battery-powered hand tools. The company has assembled the following data pertaining to its two most popular products: Drill Saw Direct Materials $60 110 Direct Labour 40 90 Manufacturing Overhead* 160 320 Cost if purchased from outside supplier 200 380 Annual Demand in units 200,000 220,000 * The manufacturing overhead is applied at a rate of $80 per machine hour used in production. Twenty-five percent of the MOH is variable in nature and the remaining...
An assembly line has been designed to make battery-powered beverage mixers. Task details are shown in...
An assembly line has been designed to make battery-powered beverage mixers. Task details are shown in the table below: Station Task Assigned Task Time (minutes) 1 1 3.0 2 3; 4 1.5; 2.0 3 2; 5; 6 1.5; 1.5; 2.0 4 7 3.0 5 8 2.5 6 9; 10; 11 2.0; 1.0; 1.0 (a) What is the assigned cycle time (in minutes)? (b) What is the maximum output rate of this line in mixers per hour? (c) What is the...
To-Air-is-Human, Inc. (TAH) manufactures lightweight unpowered and human-powered aircraft. They have decided to produce a brand-new...
To-Air-is-Human, Inc. (TAH) manufactures lightweight unpowered and human-powered aircraft. They have decided to produce a brand-new low-cost two-seater glider kit for the consumer market, which they will sell direct to the consumer.  They will have a dedicated facility that they rent for $100,000 for the year. They will also rent two large molding machines for fabrication of the glider hull at $4500 apiece. The production line will be manned by four skilled workers, whose salaries total $115,000 for the year. Hull...
Juliette formed a new business to sell sporting goods this year. The business opened its doors...
Juliette formed a new business to sell sporting goods this year. The business opened its doors to customers on June 1. Determine the amount of start-up costs Juliette can immediately expense (not including the portion of the expenditures that are amortized over 180 months) this year in the following alternative scenarios: (Leave no answer blank. Enter zero if applicable.) a. She incurred start-up costs of $4,400. ANSWER: $4,400 b. She incurred start-up costs of $46,000. ANSWER: $5,000 c. She incurred...
8. Juliette formed a new business to sell sporting goods this year. The business opened its...
8. Juliette formed a new business to sell sporting goods this year. The business opened its doors to customers on June 1. Determine the amount of start-up costs Juliette can immediately expense (not including amortization) this year in the following alternative scenarios. (Leave no answer blank. Enter zero if applicable.) a. She incurred start-up costs of $2,200. Amount of start-up costs immediately expensed ? b. She incurred start-up costs of $40,250. Amount of start-up costs immediately expensed ? c. She...
A new car that is a gas- and electric-powered hybrid has recently hit the market. The...
A new car that is a gas- and electric-powered hybrid has recently hit the market. The distance travelled on 1 gallon of fuel is normally distributed with a mean of 50 miles and a standard deviation of 8 miles. Find the probability of the following events: A. The car travels more than 55 miles per gallon. Probability = B. The car travels less than 47 miles per gallon. Probability = C. The car travels between 42 and 53 miles per...
A new car that is a gas- and electric-powered hybrid has recently hit the market. The...
A new car that is a gas- and electric-powered hybrid has recently hit the market. The distance traveled on 1 gallon of fuel is normally distributed with a mean of 45 miles and a standard deviation of 7 miles. Find the probability of the following events: A. The car travels more than 53 miles per gallon. Probability =   B. The car travels less than 42 miles per gallon. Probability =   C. The car travels between 39 and 52 miles per...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT