Budgeted balances at January 31, 2018 are as follows: Cash ? Accounts Receivable ? Inventory ? Property, plant and Equipment (net) $1,175,600 Accounts Payable ? Long-term liabilities 182,000 Stockholders equity ? Selected budget information for December 2017 follows: Cash balance, December 31, 2017 $124,000 Budgeted Sales $1,650,000 Budgeted materials purchases $820,000 Customer invoices are payable within 30 days. From past experience, Skulas’s accountant projects 40% of invoices will be collected in the month invoiced, and 60% will be collected in the following month. Accounts payable relates only to the purchase of direct materials. Direct materials are purchased on credit with 50% of direct materials purchases paid during the month of the purchase, and 50% paid in the month following purchase. Fixed manufacturing overhead costs include $64,000 of depreciation costs and fixed nonmanufacturing overhead costs include $10,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, Skulas’s board of directors voted to pay a $160,000 dividend to stockholders on January 31, 2018. Questions: 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.
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
Skulas, Inc., manufactures and sells snowboards. Skulas manufactures a single model, the Pipex. In late 2017, Skulas’s
Materials and Labor Requirement
Direct Materials
Wood 9 Boards Feet (b.f.) per snowboard
Fiberglass 10 Yards per snowboard
Direct manufacturing labor 5 hours per snowboard
Skulas’s CEO expects to sell 2,900 snowboards during January 2018 at an estimated retail price of $650 per board. Further, the CEO expects 2018 beginning inventory of 500 snowboards and would like to end January 2018 with 200 snowboards in stock.
Direct Materials Inventories
Begining Inventory 1/1/2018 Ending Inventory 1/31/2018
Wood 2,040 b.f. 1,540 b.f.
Fiberglass 1,040 yards 2,040 yards
Alternative Text Variable manufacturing overhead is $7 per direct manufacturing labor-hour. There are also $81,000 in fixed
Other data include:
2017 Unit Price 2018 Unit Price
Wood $32.00 per b.f. $34.00 per b.f.
Fiberglass $8.00 per yard $9.00 per yar
Direct manu. labor $28.00 per hour $29.00 per hour
Question:
Budgeted balances at January 31, 2018 are as follows:
Cash ?
Accounts Receivable ?
Inventory ?
Property, plant and Equipment (net) $1,175,600
Accounts Payable ?
Long-term liabilities 182,000
Selected budget information for December 2017 follows:
Cash balance, December 31, 2017 $124,000
Budgeted Sales $1,650,000
Budgeted materials purchases $820,000
Customer invoices are payable within 30 days. From past experience, Skulas’s accountant projects 40% of invoices will be collected in the month invoiced, and 60% will be collected in the following month. Accounts payable relates only to the purchase of direct materials. Direct materials are purchased on credit with 50% of direct materials purchases paid during the month of the purchase, and 50% paid in the month following purchase. Fixed manufacturing overhead costs include $64,000 of depreciation costs and fixed nonmanufacturing overhead costs include $10,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, Skulas’s board of directors voted to pay a $160,000 dividend to stockholders on January 31, 2018.
Questions:
-
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.
-
We’ll answer the second question since the requirement of the first question is not there. Please submit a new question specifying the one you’d like answered.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 3 images