The Production Department of Hruska Corporation has submitted the following forecast of units to be produced...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The Production Department of Hruska Corporation has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year: Units to be produced 10,000 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 12,000 13,000 14,000 Each unit requires 0.2 direct labor-hours and direct laborers are paid $12.00 per hour. In addition, the variable manufacturing overhead rate is $1.75 per direct labor-hour. The fixed manufacturing overhead is $86,000 per quarter. The only noncash element of manufacturing overhead is depreciation, which is $23,000 per quarter. Required: 1. Calculate the company's total estimated direct labor cost for each quarter of the upcoming fiscal year and for the year as a whole. 2&3. Calculate the company's total estimated manufacturing overhead cost and the cash disbursements for manufacturing overhead for each quarter of the upcoming fiscal year and for the year as a whole. Complete this question by entering your answers in the tabs below. Req 1 Req 2 and 3 Calculate the company's total estimated direct labor cost for each quarter of the upcoming fiscal year and for the year as a whole. 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year Total direct labor cost Total manufacturing overhead Cash disbursements for manufacturing overhead 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year You have been asked to prepare a December cash budget for Ashton Company, a distributor of exercise equipment. The following information is available about the company's operations: a. The cash balance on December 1 is $40,000. b. Actual sales for October and November and expected sales for December are as follows: Cash sales Sales on account October November December $ 65,000 $ 70,000 $ 83,000 $400,000 $525,000 $600,000 Sales on account are collected over a three-month period as follows: 20% collected in the month of sale, 60% collected in the month following sale, and 18% collected in the second month following sale. The remaining 2% is uncollectible. c. Purchases of inventory will total $280,000 for December. Thirty percent of a month's inventory purchases are paid during the month of purchase. The accounts payable remaining from November's inventory purchases total $161,000, all of which will be paid in December. d. Selling and administrative expenses are budgeted at $430,000 for December. Of this amount, $50,000 is for depreciation. e. A new web server for the Marketing Department costing $76,000 will be purchased for cash during December, and dividends totaling $9,000 will be paid during the month. f. The company maintains a minimum cash balance of $20,000. An open line of credit is available from the company's bank to increase its cash balance as needed. Required: 1. Calculate the expected cash collections for December. 2. Calculate the expected cash disbursements for merchandise purchases for December. 3. Prepare a cash budget for December. Indicate in the financing section any borrowing that will be needed during the month. Assume that any interest will not be paid until the following month. 1. Calculate the expected cash collections for December. 2. Calculate the expected cash disbursements for merchandise purchases for December. Total cash collections Cash disbursements for merchandise purchases Prepare a cash budget for December. Indicate in the financing section any borrowing that will be needed during the month. Assume that any interest will not be paid until the following month. Ashton Company Cash Budget For the Month of December Beginning cash balance Add collections from customers Total cash available Less cash disbursements: Payments to suppliers for inventory Selling and administrative expenses New web server Dividends paid Total cash disbursements Excess (deficiency) of cash available over disbursements Financing: Borrowings Repayments Interest Total financing Ending cash balance The Production Department of Hruska Corporation has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year: Units to be produced 10,000 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 12,000 13,000 14,000 Each unit requires 0.2 direct labor-hours and direct laborers are paid $12.00 per hour. In addition, the variable manufacturing overhead rate is $1.75 per direct labor-hour. The fixed manufacturing overhead is $86,000 per quarter. The only noncash element of manufacturing overhead is depreciation, which is $23,000 per quarter. Required: 1. Calculate the company's total estimated direct labor cost for each quarter of the upcoming fiscal year and for the year as a whole. 2&3. Calculate the company's total estimated manufacturing overhead cost and the cash disbursements for manufacturing overhead for each quarter of the upcoming fiscal year and for the year as a whole. Complete this question by entering your answers in the tabs below. Req 1 Req 2 and 3 Calculate the company's total estimated direct labor cost for each quarter of the upcoming fiscal year and for the year as a whole. 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year Total direct labor cost Total manufacturing overhead Cash disbursements for manufacturing overhead 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year You have been asked to prepare a December cash budget for Ashton Company, a distributor of exercise equipment. The following information is available about the company's operations: a. The cash balance on December 1 is $40,000. b. Actual sales for October and November and expected sales for December are as follows: Cash sales Sales on account October November December $ 65,000 $ 70,000 $ 83,000 $400,000 $525,000 $600,000 Sales on account are collected over a three-month period as follows: 20% collected in the month of sale, 60% collected in the month following sale, and 18% collected in the second month following sale. The remaining 2% is uncollectible. c. Purchases of inventory will total $280,000 for December. Thirty percent of a month's inventory purchases are paid during the month of purchase. The accounts payable remaining from November's inventory purchases total $161,000, all of which will be paid in December. d. Selling and administrative expenses are budgeted at $430,000 for December. Of this amount, $50,000 is for depreciation. e. A new web server for the Marketing Department costing $76,000 will be purchased for cash during December, and dividends totaling $9,000 will be paid during the month. f. The company maintains a minimum cash balance of $20,000. An open line of credit is available from the company's bank to increase its cash balance as needed. Required: 1. Calculate the expected cash collections for December. 2. Calculate the expected cash disbursements for merchandise purchases for December. 3. Prepare a cash budget for December. Indicate in the financing section any borrowing that will be needed during the month. Assume that any interest will not be paid until the following month. 1. Calculate the expected cash collections for December. 2. Calculate the expected cash disbursements for merchandise purchases for December. Total cash collections Cash disbursements for merchandise purchases Prepare a cash budget for December. Indicate in the financing section any borrowing that will be needed during the month. Assume that any interest will not be paid until the following month. Ashton Company Cash Budget For the Month of December Beginning cash balance Add collections from customers Total cash available Less cash disbursements: Payments to suppliers for inventory Selling and administrative expenses New web server Dividends paid Total cash disbursements Excess (deficiency) of cash available over disbursements Financing: Borrowings Repayments Interest Total financing Ending cash balance
Expert Answer:
Related Book For
Managerial Accounting
ISBN: 9780073526706
12th Edition
Authors: Ray H. Garrison, Eric W. Noreen, Peter C. Brewer
Posted Date:
Students also viewed these accounting questions
-
A school is required by the government to give some randomly chosen students a standardized test. From previous experience, the school knows about 68% of their students will receive passing scores in...
-
Journalize the following adjustments. (Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account...
-
22. T Pty Ltd is a manufacturer of tennis equipment and fashion wear. The statement of financial position as at 30 June 2024 and details of expenses and revenues for the year ending 30 June 2024 are...
-
The purpose of this exercise is to compare the return on Tesla stock with the return on a set of options strategies. All returns should be calculated between November 15 and November 25. The Excel...
-
Suppose that there is an increase in national income in a country. Under a fixed exchange rate system, according to the monetary approach, will the countrys balance of payments (official reserve...
-
Find ZT and I in the circuit of Fig. 9.71. 40 6
-
Job-order costing is usually identified with manufacturing companies. However, service industries and not-for-profit organizations also use the method. Suppose a social service agency has a cost...
-
On February 14, 2016, Isabelle Moretti, Aida Kam, and Channade Fenandoe start a partnership to operate a marketing consulting practice. They sign a partnership agreement to split profits in a 2:3:4...
-
You may need to use the appropriate appendix table or technology to answer this question. The cost of a daily newspaper varies from city to city. However, the variation among prices remains steady...
-
The Fried Green Tomatoes Restaurant has increased its operating cycle from 100.2 days to 106 days while the cash cycle has decreased by 2.1 days. How have these changes affected the accounts payable...
-
List the five major steps needed to use a random number table. Explain how each step would be performed to select 15 accounts for confirmation from a listing of eight pages of accounts receivable...
-
Blake Advertising pays Amanda Hilton \($108,000\) per year. Hilton works 2,000 hours per year. Requirements 1. What is the hourly cost to Blake Advertising of employing Hilton? 2. What direct labor...
-
You purchase \($2,000\) worth of six-month US Treasury bills on the secondary market with a quoted yield per annum of 0.44 per cent. The bills have 24 days to maturity. How much would you pay? Use...
-
Assume that the clients internal controls over the recording and classifying of permanent asset additions are considered weak because the person responsible for recording new acquisitions has...
-
On 1 March 2011 a company raises finance by agreeing a six-month eurodollar loan for \($12\) million offered at an interest rate of 2.75 per cent. Calculate the cost of the loan in dollars. (a) on a...
-
content area top Part 1 The statement of cash flows categorizes like transactions for optimal reporting. Identify each item as a(n): LOADING...(Click the icon to view the items.) The indirect method...
-
Aztec Furnishings makes hand-crafted furniture for sale in its retail stores. The furniture maker has recently installed a new assembly process, including a new sander and polisher. With this new...
-
Can the purchase of a company by venture capitalists create value? And by trade buyers?
-
Why can we say that the mean or the median figure is the choice of an indecisive person?
-
Has a reduction in working capital of 1% the same impact on a DCF as a 1% improvement in the EBIT margin?
Study smarter with the SolutionInn App