10. Prepare the following budgets for the month of December 2013. (a) Sales. (b) Production. (c)...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
10. Prepare the following budgets for the month of December 2013. (a) Sales. (b) Production. (c) Direct materials. (d) Direct labor. (e) Selling and administrative expenses. (f) Cash. (g) Budgeted income statement. Armstrong Helmet Company Developed by Dick Wasson, Southwestern College The Business Situation Armstrong Helmet Company manufactures a unique model of bicycle helmet. The company began operations December 1, 2013. Its accountant quit the second week of operations, and the company is searching for a replacement. The com- pany has decided to test the knowledge and ability of all candidates interviewing for the position. Each candidate will be provided with the information below and then asked to prepare a series of reports, schedules, budgets, and recommenda- tions based on that information. The information provided to each candidate is as follows. Cost Items and Account Balances Administrative salaries Advertising for helmets Cash, December 1 Depreciation on factory building Depreciation on office equipment Insurance on factory building Miscellaneous expenses-factory Office supplies expense Professional fees Property taxes on factory building Raw materials used Rent on production equipment Research and development Sales commissions Utility costs-factory HELMET Wages-factory Work in process, December 1 Work in process, December 31 Raw materials inventory, December 1 Raw materials inventory, December 31 Raw material purchases Finished goods inventory. December 1 $15,500 11,000 -0- 1,500 800 1,500 1,000 300 500 400 70,000 6,000 10,000 40,000 900 70,000 -0- -0- -0- -0- 70,000 Production and Sales Data Number of helmets produced Expected sales in units for December ($40 unit sales price) Expected sales in units for January Desired ending inventory Direct materials per finished unit Direct materials cost Direct labor hours per unit Direct labor hourly rate 10,000 8,000 10,000 20% of next month's sales 1 kilogram $7 per kilogram .35 $20 Cash Flow Data Cash collections from customers: 75% in month of sale and 25% the following month. Cash payments to suppliers: 75% in month of purchase and 25% the following month. Income tax rate: 45%. Cost of proposed production equipment: $720,000. Manufacturing overhead and selling and administrative costs are paid as incurred. Desired ending cash balance: $30,000. 13. Determine the cash payback period on the proposed production equipment purchase, assuming a monthly cash flow as indicated in the cash budget (requirement 10f). 10. Prepare the following budgets for the month of December 2013. (a) Sales. (b) Production. (c) Direct materials. (d) Direct labor. (e) Selling and administrative expenses. (f) Cash. (g) Budgeted income statement. Armstrong Helmet Company Developed by Dick Wasson, Southwestern College The Business Situation Armstrong Helmet Company manufactures a unique model of bicycle helmet. The company began operations December 1, 2013. Its accountant quit the second week of operations, and the company is searching for a replacement. The com- pany has decided to test the knowledge and ability of all candidates interviewing for the position. Each candidate will be provided with the information below and then asked to prepare a series of reports, schedules, budgets, and recommenda- tions based on that information. The information provided to each candidate is as follows. Cost Items and Account Balances Administrative salaries Advertising for helmets Cash, December 1 Depreciation on factory building Depreciation on office equipment Insurance on factory building Miscellaneous expenses-factory Office supplies expense Professional fees Property taxes on factory building Raw materials used Rent on production equipment Research and development Sales commissions Utility costs-factory HELMET Wages-factory Work in process, December 1 Work in process, December 31 Raw materials inventory, December 1 Raw materials inventory, December 31 Raw material purchases Finished goods inventory. December 1 $15,500 11,000 -0- 1,500 800 1,500 1,000 300 500 400 70,000 6,000 10,000 40,000 900 70,000 -0- -0- -0- -0- 70,000 Production and Sales Data Number of helmets produced Expected sales in units for December ($40 unit sales price) Expected sales in units for January Desired ending inventory Direct materials per finished unit Direct materials cost Direct labor hours per unit Direct labor hourly rate 10,000 8,000 10,000 20% of next month's sales 1 kilogram $7 per kilogram .35 $20 Cash Flow Data Cash collections from customers: 75% in month of sale and 25% the following month. Cash payments to suppliers: 75% in month of purchase and 25% the following month. Income tax rate: 45%. Cost of proposed production equipment: $720,000. Manufacturing overhead and selling and administrative costs are paid as incurred. Desired ending cash balance: $30,000. 13. Determine the cash payback period on the proposed production equipment purchase, assuming a monthly cash flow as indicated in the cash budget (requirement 10f).
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
For the month of December 2014, Ranger Corporations records show the following information: Cash received on accounts receivable $35,000 Cash sales 30,000 Accounts receivable, December 1, 2014 80,000...
-
For the month of December 2017, Ranger Corporation's records show the following information: Cash received on accounts receivable......................$35,000 Cash...
-
A decrease in Selling and Administrative Expenses would directly impact what ratio? a. Fixed asset turnover ratio. b. Times interest earned. c. Current ratio. d. Gross profit percentage.
-
Organizational buyers are ________.
-
Takemoto Corporation borrowed $60,000 on November 1, 2011, by signing a $61,350, three-month, zero-interest-bearing note. Prepare Takemotos November 1, 2011 entry; the December 31, 2011 annual...
-
Various types of retail outlets sell toys during the holiday season. Among them are specialty toy stores, large discount toy stores, and other retailers that carry toys as only one part of their...
-
Under the random utility interpretation, an individual with utility \(U_{i j}=\) \(u_{i}\left(V_{i j}+\epsilon_{i j} ight)\), where \(j\) may be 1 or 2 , selects category corresponding to \(j=1\)...
-
The following information is available for Dylan Inc., a company whose shares are traded on the Toronto Stock Exchange: Other information: 1. For all of the fiscal year 2017, $100,000 of 6%...
-
(b) Given the formula below. Tn+1=n+n - T . Ti = 1 (i) Find the value of the next four terms after Ti [4 marks] (ii) Determine whether the answer in Question 2(b)(i) is recursive or explicit. [1 mark]
-
Thompson Distributors packages and distributes industrial supplies. A standard shipment can be packaged in a class A container, a class K container, or a class T container. A single class A container...
-
Hirt Corporation sells its product for $10 per unit. Next year, fixed expenses are expected to be $510,000 and variable expenses are expected to be $6 per unit. How many units must the company sell...
-
A dining room set was ordered on August 12, paid for on August 15 and received August 21, and had discount terms of 2/10, n/30, ROG. What is the latest date the cash discount is allowed?
-
Round to the nearest cent. A director of accounts received a bill for for a $743, dated October 9, with sales terms 5/10, 3/20, n/30 . The bill was paid October 24. Find the cash discount and net...
-
The amount of customers entering the StopOne variety store per day is normally distributed with a mean of 100 and a standard deviation of15. About what percentage of the observations lie between 85...
-
A car can travel faster when the of a road is smaller. Let's assume that the speed around a curve is to the square root of the curvature. A car is moving along the path given by f ( x ) = x ( these...
-
Determine the variable, that is being squared, the exponent, the coefficient of why, the coefficient of Z , the constant, of the equation 5 x ^ 2 + 1 8 - 3 y + z - 2 2
-
According to Garrett Hardin, what is the recommended course of action when faced with limited resources on a lifeboat surrounded by the world's poorest people? ignore the plight of the poor and focus...
-
3M Company reports the following financial statement amounts in its 10-K report: a. Compute the receivables, inventory, and PPE turnover ratios for both 2018 and 2017. (Receivables turnover and...
-
How does the product life cycle influence marketing strategy decisions?
-
What is the new product development process?
-
What is the hype cycle?
Study smarter with the SolutionInn App