Slaggs, Inc., manufactures and sells snowboards. Slaggs manufactures a single model, the Pipex. In late 2017,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Slaggs, Inc., manufactures and sells snowboards. Slaggs manufactures a single model, the Pipex. In late 2017, Slaggs's management accountant gathered the following data to prepare budgets for January 2018: (Click the icon to view the budgeted balances and additional information pertaining to the cash budget.) (Click the icon to view the additional variable and fixed manufacturing cost information.) Requirement 1. Prepare a cash budget for January 2018. Show supporting schedules for the calculation of collection of receivables and payments of accounts payable, and for disbursements for fixed manufacturing and nonmanufacturing overhead. Begin by preparing the supporting schedule for the calculation of collection of receivables. Schedule of Cash Collections (Click the icon to view the materials and labor requirements, the direct materials inventories, and additional inventory information.) (Click the icon to view the following selected January 2018 budgets: Revenue, Direct material purchases, Direct manufacturing labor cost, Variable manufacturing overhead and Ending inventory.) Read the requirements. From December 2017 sales From January 2018 sales Total collections Data Table Budgeted balances at January 31, 2018 are as follows: Cash Accounts receivable Inventory Property, plant, and equipment (net) Accounts payable Long-term liabilities Stockholders' equity $ Selected budgeted information for December 2017 follows: Cash balance, December 31, 2017 $ Budgeted sales Budgeted materials purchases ? ? ? 858,000 18,000 1,655,000 780,000 ? 186,000 ? - X Customer invoices are payable within 30 days. From past experience, Slaggs's accountant projects 45% of invoices will be collected in the month invoiced, and 55% will be collected in the following month. Accounts payable relates only to the purchase of direct materials. Direct materials are purchased on credit with 30% of direct materials purchases paid during the month of the purchase, and 70% paid in the month following purchase. Fixed manufacturing overhead costs include $42,000 of depreciation costs and fixed nonmanufacturing overhead costs include $7,000 of depreciation costs. Direct manufacturing labor and the remaining manufacturing and nonmanufacturing overhead costs are paid monthly. All property, plant, and equipment acquired during January 2018 were purchased on credit and did not entail any outflow of cash. There were no borrowings or repayments with respect to long-term liabilities in January 2018. On December 15, 2017, Slaggs's board of directors voted to pay a $190,000 dividend to stockholders on January 31, 2018. More Info - X Variable manufacturing overhead is $18 per direct manufacturing labor-hour. There are also $60,000 in fixed manufacturing overhead costs budgeted for January 2018. Slaggs combines both variable and fixed manufacturing overhead into a single rate based on direct manufacturing labor-hours. Variable marketing costs are allocated at the rate of $330 per sales visit. The marketing plan calls for 42 sales visits during January 2018. Finally, there are $39,000 in fixed nonmanufacturing costs budgeted for January 2018. Data Table Direct materials Wood Fiberglass Direct manufacturing labor Materials and Labor Requirements Wood Fiberglass Slaggs' CEO expects to sell 3,700 snowboards during January 2018 at an estimated retail price of $960 per board. Further, the CEO expects 2018 beginning inventory of 500 snowboards and would like to end January 2018 with 800 snowboards in stock. Other data include: 15 board feet (b.f.) per snowboard 13 yards per snowboard 3 hours per snowboard Direct Materials Inventories Beginning Inventory 1/1/2018 2,080 b.f. 1,080 yards Wood Fiberglass Direct manufacturing labor $ $ $ Ending Inventory 1/31/2018 1,580 b.f. 2,080 yards 2017 Unit Price 36.00 per b.f. 12.00 per yard 32.00 per hour $ $ $ 2018 Unit Price 38.00 per b.f. 13.00 per yard 33.00 per hour The inventoriable unit cost for ending finished-goods inventory on December 31, 2017, is $175.00. Assume Slaggs uses a FIFO inventory method for both direct materials and finished goods. Ignore work in process in your calculations. X Reference Snowboards Physical Units Budget To be used in production Purchases Add target ending inventory Total requirement Deduct beginning inventory Purchases to be made Cost Budget Revenue Budget For January 2018 Units Selling price 3,700 $ Direct Materials Purchases Budget For January 2018 Wood 960 $ 60,000 b.f. 1,580 b.f. 61,580 b.f. 2,080 b.f. 59,500 $ 2,261,000 Materials Total revenues b.f. 3,552,000 Fiberglass 52,000 yards 2,080 yards 54,080 yards 1,080 yards 53,000 yards $ 689,000 Direct Manufacturing Labor Costs Budget Total $ 2,950,000 X Snowboards Total labor hours 12,000 Output Units Produced 4,000 X Direct Manufacturing Labor Costs Budget For January 2018 Total Hours 12,000 Direct materials Wood Fiberglass DMLH per Unit 3 x Variable manufacturing overhead rate = Variable manufacturing overhead costs 18 $ 216,000 Finished goods Snowboard Total ending inventory Ending Inventories Budget For January 2018 Quantity 1,580 2,080 800 Hourly Wage Rate $ $ 33 Cost per unit $ 38 13 907 $ $ Total $ 396,000 Total 60,040 27,040 725,600 812,680 Hi 1. 2. 3. 4. Requirements - X Prepare a cash budget for January 2018. Show supporting schedules for the calculation of collection of receivables and payments of accounts payable, and for disbursements for fixed manufacturing and nonmanufacturing overhead. Slaggs is interested in maintaining a minimum cash balance of $90,000 at the end of each month. Will Slaggs be in a position to pay the $190,000 dividend on January 31? Why do Slaggs's managers prepare a cash budget in addition to the revenue, expenses, and operating income budget? Prepare a budgeted balance sheet for January 31, 2018 by calculating the January 31, 2018 balances in (a) cash (b) accounts receivable (c) inventory (d) accounts payable and (e) plugging in the balance for stockholders' equity. Slaggs, Inc., manufactures and sells snowboards. Slaggs manufactures a single model, the Pipex. In late 2017, Slaggs's management accountant gathered the following data to prepare budgets for January 2018: (Click the icon to view the budgeted balances and additional information pertaining to the cash budget.) (Click the icon to view the additional variable and fixed manufacturing cost information.) Requirement 1. Prepare a cash budget for January 2018. Show supporting schedules for the calculation of collection of receivables and payments of accounts payable, and for disbursements for fixed manufacturing and nonmanufacturing overhead. Begin by preparing the supporting schedule for the calculation of collection of receivables. Schedule of Cash Collections (Click the icon to view the materials and labor requirements, the direct materials inventories, and additional inventory information.) (Click the icon to view the following selected January 2018 budgets: Revenue, Direct material purchases, Direct manufacturing labor cost, Variable manufacturing overhead and Ending inventory.) Read the requirements. From December 2017 sales From January 2018 sales Total collections Data Table Budgeted balances at January 31, 2018 are as follows: Cash Accounts receivable Inventory Property, plant, and equipment (net) Accounts payable Long-term liabilities Stockholders' equity $ Selected budgeted information for December 2017 follows: Cash balance, December 31, 2017 $ Budgeted sales Budgeted materials purchases ? ? ? 858,000 18,000 1,655,000 780,000 ? 186,000 ? - X Customer invoices are payable within 30 days. From past experience, Slaggs's accountant projects 45% of invoices will be collected in the month invoiced, and 55% will be collected in the following month. Accounts payable relates only to the purchase of direct materials. Direct materials are purchased on credit with 30% of direct materials purchases paid during the month of the purchase, and 70% paid in the month following purchase. Fixed manufacturing overhead costs include $42,000 of depreciation costs and fixed nonmanufacturing overhead costs include $7,000 of depreciation costs. Direct manufacturing labor and the remaining manufacturing and nonmanufacturing overhead costs are paid monthly. All property, plant, and equipment acquired during January 2018 were purchased on credit and did not entail any outflow of cash. There were no borrowings or repayments with respect to long-term liabilities in January 2018. On December 15, 2017, Slaggs's board of directors voted to pay a $190,000 dividend to stockholders on January 31, 2018. More Info - X Variable manufacturing overhead is $18 per direct manufacturing labor-hour. There are also $60,000 in fixed manufacturing overhead costs budgeted for January 2018. Slaggs combines both variable and fixed manufacturing overhead into a single rate based on direct manufacturing labor-hours. Variable marketing costs are allocated at the rate of $330 per sales visit. The marketing plan calls for 42 sales visits during January 2018. Finally, there are $39,000 in fixed nonmanufacturing costs budgeted for January 2018. Data Table Direct materials Wood Fiberglass Direct manufacturing labor Materials and Labor Requirements Wood Fiberglass Slaggs' CEO expects to sell 3,700 snowboards during January 2018 at an estimated retail price of $960 per board. Further, the CEO expects 2018 beginning inventory of 500 snowboards and would like to end January 2018 with 800 snowboards in stock. Other data include: 15 board feet (b.f.) per snowboard 13 yards per snowboard 3 hours per snowboard Direct Materials Inventories Beginning Inventory 1/1/2018 2,080 b.f. 1,080 yards Wood Fiberglass Direct manufacturing labor $ $ $ Ending Inventory 1/31/2018 1,580 b.f. 2,080 yards 2017 Unit Price 36.00 per b.f. 12.00 per yard 32.00 per hour $ $ $ 2018 Unit Price 38.00 per b.f. 13.00 per yard 33.00 per hour The inventoriable unit cost for ending finished-goods inventory on December 31, 2017, is $175.00. Assume Slaggs uses a FIFO inventory method for both direct materials and finished goods. Ignore work in process in your calculations. X Reference Snowboards Physical Units Budget To be used in production Purchases Add target ending inventory Total requirement Deduct beginning inventory Purchases to be made Cost Budget Revenue Budget For January 2018 Units Selling price 3,700 $ Direct Materials Purchases Budget For January 2018 Wood 960 $ 60,000 b.f. 1,580 b.f. 61,580 b.f. 2,080 b.f. 59,500 $ 2,261,000 Materials Total revenues b.f. 3,552,000 Fiberglass 52,000 yards 2,080 yards 54,080 yards 1,080 yards 53,000 yards $ 689,000 Direct Manufacturing Labor Costs Budget Total $ 2,950,000 X Snowboards Total labor hours 12,000 Output Units Produced 4,000 X Direct Manufacturing Labor Costs Budget For January 2018 Total Hours 12,000 Direct materials Wood Fiberglass DMLH per Unit 3 x Variable manufacturing overhead rate = Variable manufacturing overhead costs 18 $ 216,000 Finished goods Snowboard Total ending inventory Ending Inventories Budget For January 2018 Quantity 1,580 2,080 800 Hourly Wage Rate $ $ 33 Cost per unit $ 38 13 907 $ $ Total $ 396,000 Total 60,040 27,040 725,600 812,680 Hi 1. 2. 3. 4. Requirements - X Prepare a cash budget for January 2018. Show supporting schedules for the calculation of collection of receivables and payments of accounts payable, and for disbursements for fixed manufacturing and nonmanufacturing overhead. Slaggs is interested in maintaining a minimum cash balance of $90,000 at the end of each month. Will Slaggs be in a position to pay the $190,000 dividend on January 31? Why do Slaggs's managers prepare a cash budget in addition to the revenue, expenses, and operating income budget? Prepare a budgeted balance sheet for January 31, 2018 by calculating the January 31, 2018 balances in (a) cash (b) accounts receivable (c) inventory (d) accounts payable and (e) plugging in the balance for stockholders' equity.
Expert Answer:
Answer rating: 100% (QA)
1 Cash Budget Cash Balance Beginning 12000 Add Receipts Collections from Customers 1322000 Total Cas... View the full answer
Related Book For
Horngrens Cost Accounting A Managerial Emphasis
ISBN: 978-0134475585
16th edition
Authors: Srikant M. Datar, Madhav V. Rajan
Posted Date:
Students also viewed these accounting questions
-
NPV Calculations Output You are a program manager for the procurement function of a global company. You are building a case for a new training program that will net financial benefits as well as...
-
For the network shown below, determine the transfer function, G(s) = Vo(s)/V;(s). Show the details of. your work. Write your answer on a white typewriting paper, scan it in JPEG format, and paste it...
-
You want $100,000 college fund in 15 years. How much will you have to deposit now under the scenario below. Assume that you make no deposits into the account after the initial deposit. An APR of 4.4%...
-
The drawing shows a frictionless incline and pulley. The two blocks are connected by a wire (mass per unit length = 0.0250 kg/m) and remain stationary. A transverse wave on the wire has a speed of...
-
A 4.0-cm cube of aluminum is initially at 450C and is suddenly exposed to a convection environment at 100C with h = 120 W/m2 C. How long does it take the cube to cool to 250C?
-
Using nodal analysis, find v0 in the circuit in Fig. 3.57. Figure 3.57 3 5 3 V 1
-
Use the method of Exercise 4 to find the variance of a lognormal variable in terms of the parameters of the underlying normal variable Data from Exercises 4 Suppose that \(u=e^{w}\), where \(w\) is...
-
Jillian Limited ( JL) issued a financial instrument with the following terms: A face value of $ 100. Not secured by any assets of the entity (unsecured). Redeemable in cash at the option of the...
-
Accounts receivable Accounts payable Buildings Cash $ 18,000 Long-term notes payable 11,000 Office supplies 45,000 Prepaid insurance 7,000 Unearned services revenue Compute Chavez Company's current...
-
Funtime, Inc., manufactures video game machines. Market saturation and technological innovations caused pricing pressures that resulted in declining profits. To stem the slide in profits until new...
-
7) Consider a competitive exchange economy with two individuals, Adam and Beth, and two goods, candy bars X and cookies, Y. The economy has 30 units of each good. Initially, Adam has 30 candy bars,...
-
Just as the 7-inch, 45 RPM single record was the main form of selling recorded rock in the 1950s, which was replaced by the 12-inch 33 RPM LP in the 1960s and 1970s, which was replaced by cassette...
-
Semester conclude discussion Part 1: Initial Post As we conclude the semester, reflect on some of the things that you learned about public speaking and your growth as a communicator throughout the...
-
Four applicants are applying for the same position in a major corporation. All hold post-graduate degrees in their disciplines, have at least ten years of experience in their fields, and are members...
-
"How do evolving norms and values within societies contribute to the perpetuation or transformation of social hierarchies and power dynamics, and what role do social institutions play in mediating...
-
n what ways do globalization and technological advancements impact social identities and cultural practices, and how do individuals and communities negotiate their sense of belonging and cultural...
-
Identify those that have stake in the outcome of the collaborative Identification of the problem to be solved- Identify barriers to creating a solution Clarification of the agreed outcome Clarify the...
-
Determine by direct integration the values of x for the two volumes obtained by passing a vertical cutting plane through the given shape of Fig. 5.21. The cutting plane is parallel to the base of the...
-
The Garvis Company uses an absorption-costing system based on standard costs. Variable manufacturing cost consists of direct material cost of $4.50 per unit and other variable manufacturing costs of...
-
Mississippi Manufacturing makes a component called B2040. This component is manufactured only when ordered by a customer, so Mississippi keeps no inventory of B2040. The list price is $112 per unit,...
-
Give two examples of nonfinancial measures of internal-business-process quality.
-
The percentage of heights between 148 centimeters and 170 centimeters
-
The percentage of heights between 159 centimeters and 165 centimeters
-
In this section, it was noted that the standard deviation of sample means is s/1n. In that expression, what does s represent and what does n represent?
Study smarter with the SolutionInn App