Question 17 -/1 View Policies Current Attempt in Progress A company budgeted unit sales of 124000 units for January, 2017 and 140000 units for February 2017. The has a policy of having an inventory of units on hand at the end of each month equal to 30% of next month's budgeted unit sales. If there were 37200 units of inventory on hand on December 31, 2016, how many units should be produced in January, 2017 in order for the company to meet its goals? company O 166000 units O 119200 units O 128800 units O 124000 units (aD 11 ? A hp १०४ s hoil prt sc home delete 44 % unu backspace 6 P WOU nter K G pause t shih ctri Σ I cO
Q: On January 1, 2019 the Jindal Steel Company budget committee has reached agreement on the following…
A: Ending finished goods inventory (First quarter) = 16000*30%…
Q: A company budgeted unit sales of 224000 units for January, 2017 and 260000 units for February 2017.…
A: The production budget is prepared to estimate the units to be produced during the period.
Q: PRODUCTION BUDGET PRODUCTION BUDGET Flower Horn, Inc. reported the following information for 2015:…
A: The budget is prepared to estimate the requirements for the future period.
Q: Question 7 View Policies Current Attempt in Progress A company has budgeted direct materials…
A: Budgeted cash payments are a part of cash budgets that represents the amount of cash that is…
Q: Echo Amplifiers prepared the following sales budget for the first quarter of 2018: Jan. Feb. Mar.…
A: The selling and administrative expenses are the expenses incurred to sell the product and other…
Q: PROBLEM 7-H CASH DISBURSEMENTS BUDGET A 2016 cash budget is being prepared for the purchase of TOBI,…
A: In simple terms, budgets are the estimations of revenues and expenses for the future period.…
Q: XYZ Company”s budgeted for 1st quarter 2017 are as follows Sales Direct Material Purchases…
A: (a) (2) Compute the expected payments for direct materials:
Q: (15) Use this information about Nuthatch Corporation to answer the question that follows. Nuthatch…
A: Cash budget means expected cash receipts and expected cash payment with opening and closing cash…
Q: LB Enterprises (LB) is preparing its budget for the first quarter of 2019. LB's balance sheet as of…
A: The production budget is prepared too calculate the total number of units to be produced during the…
Q: Question #12 At the end of November 2016, Caribbean Productions Ltd had 700 units of product…
A: Calculation of total Product cost ; Product cost = Direct material + Direct labor + Variable…
Q: Question 1 Syntex Corporation has the following Production Budget data: Expected Sales in Units…
A: Hi! Thank you for the question, As per the honor code, we'll answer the first question since the…
Q: LB Enterprises (LB) is preparing its budget for the first quarter of 2019. LB's balance sheet as of…
A: Direct material purchase budget determines the measure of direct materials that must be purchased by…
Q: Example #1 PRODUCTION BUDGET Clapton Company's sales budget shows the following projections for the…
A: The budget is prepared to estimate the revenues, expenditure and other requirements for the future.
Q: Use this information about Dove Corporation to answer the question that follows. Dove Corporation…
A: Expected cash collection = cash sales for the month + collection of 70% of credit sale for same…
Q: Mindc Exercise 4-25 A sales budget for the first five months of 2021 is given on a certain product…
A: Purchase budget is prepared to estimate the amount of money to be spent for procuring the goods or…
Q: PROBLEM 7-H CASH DISBURSEMENTS BUDGET A 2016 cash budget is being prepared for the purchase of TOBI,…
A: Cash disbursements budget is used to project the amount of cash to be disbursed during the budget…
Q: Required: prepare budget of purchase for each of the first three months of 2011 prepare separate…
A: The details of budget for the year 2011 are given. Required prepare budget of purchase for each…
Q: The Plantd’ Company’s budgeted sales for the first quarter of 2020 are as follows:…
A: This question deals with the preparation of cash budget. Cash budget is prepared by the management…
Q: -/1 Question 13 View Policies Current Attempt in Progress The following information is taken from…
A: The production budget refers to that budget which forecasts the production for the future accounting…
Q: Daybook Inc. projected sales of 400,000 personal journals for 20Y6. The estimated January 1, 20Y6,…
A: Budgeted production (in units) = Budgeted sales + Desired ending inventory - Beginning Inventory
Q: 7. Hayma Company's sales budget for 2022 in units for the next five months is as follows: January…
A: Solution:- Calculation of units produced in January as follows under:-
Q: LB Enterprises (LB) is preparing its budget for the first quarter of 2019. LB's balance sheet as of…
A: The manufacturing overhead is the sum of all the expenses indirectly related to production like…
Q: Question 20 /1 View Policies Current Attempt in Progress Vaughn Manufacturing budgets on an annual…
A: A Budget statement is a proper articulation of assessed income and costs dependent on tentative…
Q: Exercise 20-5 (Algo) Manufacturing: Production budget LO P1 Tyler Company budgets the following unit…
A: Production budget is prepare to estimate the units to be produce for expected sales. It can be…
Q: Question 1 TinyTom makes one product, which sells for $70 each, and prepares functional budgets on a…
A: Note: Hi! Thank you for the question, As per the honor code, we are allowed to answer three…
Q: (b) A sales budget is given below for one of the products manufactured by N.Ltd .For six months…
A: For Preparation of purchase budget of NH2 it is required to prepare production budget of the…
Q: Salinger Inc., budgeted sales of 30,000 units of its product in January, 2016. Budgeted inventory…
A: Production means number of units produced during the specified period. Sales = Opening stock +…
Q: Benet Company has budgeted the following unit sales: 2017 2016 Quarter Units Quarter Units 1 105,000…
A: Workings: The given information: Inventory at the end of each quarter equal to 20 % of the next…
Q: Regina Soap Co.. Budgeted Income Statement For the Year Ending December 31, 2021 Sales Cost of goods…
A: Income Statement: An income statement is a financial document that tells you how much money the firm…
Q: Question 18 -/1 View Policies Current Attempt in Progress At January 1, 2016, Concord Corporation…
A: The correct answer is 1,505,280.
Q: 8-3
A: …
Q: LB Enterprises (LB) is preparing its budget for the first quarter of 2019. LB's balance sheet as of…
A: The material purchase of the march of $12,750 is computed by adding 75% of total material cost,…
Q: LB Enterprises (LB) is preparing its budget for the first quarter of 2019. LB's balance sheet as of…
A: Budgeting is an important part of the business process. Without budgeting a business cannot track…
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
- Forecast sales volume and sales budget For 2016, Raphael Frame Company prepared the .sales budget that follows. At the end of December 2016, the following unit sales data were reported for the year. Unit Sales 8" 10" Frame 12" 16" Frame East 8,755 3,686 Central 6,510 3,090 West 12,348 5,616 For the year ending December 31, 2017, unit sales are expected to follow die patterns established during the year ending December 31, 2016. The unit selling price for the 8" 10" frame is expected to increase to 17 and die unit selling price for die 12" 16" frame is expected to increase to 32, effective January 1, 2017. Instructions 1. Compute the increase or decrease of actual unit sales for the year ended December 31, 2016, over budget. Place your answers in a columnar table with the following format: Unit Sales, Year Ended 2016 Increase (Decrease) Actual Over Budget Budget Actual Sales Amount Percent 8" 10" Frame: East Central West 12" 16" Frame: East Central West 2. Assuming that the increase or decrease in actual sales to budget indicated in part (1) is to continue in 2017, compute the unit sales volume to be used for preparing the sales budget for the year ending December 31, 2017. Place your answers in a columnar table similar to that in part (1) but with the following column heads. Round budgeted units to the nearest unit. 2016 Actual Units Percentage Increase (Decrease) 2017 Budgeted Units (rounded) 3. Prepare a sales budget for the year ending December 31, 2017.Budgeted income statement and balance sheet As a preliminary to requesting budget estimates of sales, costs, and expenses for the fiscal year beginning January 1, 2017, the following tentative trial balance as of December 31, 2016, is prepared by the Accounting Department of Regina Soap Co.: Cash............................................................. 85,000 Accounts Receivable............................................... 125,600 Finished Goods................................................... 69,300 Work in Process................................................... 32,500 Materials......................................................... 48,900 Prepaid Expenses................................................. 2,600 Plant and Equipment.............................................. 325,000 Accumulated Depreciation Plant and Equipment.................. 156,200 Accounts Payable................................................. 62,000 Common Stock, 10 par........................................... 180,000 Retained Earnings................................................. 290,700 688,900 688,900 Factory output and sales for 2017 are expected to total 200,000 units of product, which are to be sold at 5.00 per unit. The quantities and costs of the inventories at December 31, 2017, are expected to remain unchanged from the balances at The beginning of the year. Budget estimates of manufacturing costs and operating expenses for the year are summarized as follows: Estimated Costs and Expenses Cost of goods manufactured and sold: Fixed (Total for Year) Direct materials................................................ 1.10 Direct labor.................................................... 0.65 Factory overhead: Depreciation of plant and equipment.......................... 40,000 Other factory overhead....................................... 12,000 0.40 Selling expenses: Sales salaries and commissions.................................. 46,000 0.45 Advertising.................................................... 64,000 Miscellaneous selling expense.................................. 6,000 0.25 Administrative expenses: Office and officers salaries...................................... 72,400 0.12 Supplies....................................................... 5,000 0.10 Miscellaneous administrative expense........................... 4,000 0.05 Balances, of accounts receivable, prepaid expenses, and accounts payable at the end of the year are not expected to differ significantly from the beginning balances. Federal income tax of 30,000 on 2017 taxable income will be paid during 2017. Regular quarterly cash dividends of 0.15 per share are expected to be declared and paid in March, June, September, and December on 18,000 shares of common stock outstanding. It is anticipated that fixed assets will be purchased for 75,000 cash in May. Instructions 1. Prepare a budgeted income statement for 2017. 2. Prepare a budgeted balance sheet as of December 31, 2017, with supporting calculations.CASH BUDGETING Helen Bowers, owner of Helens Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2016 and 2017. May 2016 180,000 June 180,000 July 360,000 August 540,000 September 720,000 October 360,000 November 360,000 December 90,000 January 2017 180,000 Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale. 75%; collected the second month following the sale, 15%. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus raw materials: May 2016 90,000 June 90,000 July 126,000 August 882,000 September 306,000 October 234,000 November 162,000 December 90,000 General and administrative salaries are approximately 27,000 a month. Lease payments under long-term leases are 9,000 a month. Depredation charges are 36,000 a month. Miscellaneous expenses are 2,700 a month. Income tax payments of 63,000 are due in September and December. A progress payment of 180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be 132,000, and a minimum cash balance of 90,000 should be maintained throughout the cash budget period. a. Prepare a monthly cash budget for the last 6 months of 2016. b. Prepare monthly estimates of the required financing or excess fundsthat is, the amount of money Bowers will need to borrow or will have available to invest. c. Now suppose receipts from sales come in uniformly during the month (that is, cash receipts come in at the rate of 1/30 each day), but all outflows must be paid on the 5th. Will this affect the cash budget? That is, will the cash budget you prepared be valid under these assumptions? If not, what could be done to make a valid estimate of the peak financing requirements? No calculations are required, although if you prefer, you can use calculations to illustrate the effects. d. Bowers sales are seasonal; and her company produces on a seasonal basis, just ahead of sales. Without making any calculations, discuss how the companys current and debt ratios would vary during the year if ail financial requirements were met with short-term bank loans. Could changes in these ratios affect the firms ability to obtain bank credit? Explain.
- Forecast sales volume and sales budget Sentinel Systems Inc. prepared the following sales budget for 2016: At the end of December 2016, the following unit sales data were reported for the year: For the year ending December 31 , 2017, unit sales are expected to follow the patterns established during the year ending December 31, 2016. The unit selling price for the Home Alert System is expected to increase to 250, and the unit selling price for the Business Alert System is expected to be decreased to 820, effective January 1, 2017. Instructions 1. Compute the increase or decrease of actual unit sales for the year ended December 31, 2016, over budget. Place your answers in a columnar table with the following format: 2. Assuming that the increase or decrease in actual sales to budget indicated in part (1) is to continue in 2017, compute the unit sales volume to be used for preparing the sales budget for the year ending December 31, 2017. Place your answers in a columnar table similar to that in part (1) but with the following column heads. Round budgeted units to the nearest unit. 3. Prepare a sales budget for the year ending December 31, 2017.Budgeted income statement and balance sheet As a preliminary to requesting budget estimates of sales, costs, and expenses for the fiscal year beginning January 1, 20Y8, the following tentative trial balance as of December 31, 20Y7, is prepared by the Accounting Department of Mesa Publishing Co.: Cash 26,000 Accounts Receivable 23,800 Finished Goods 16,900 Work in Process 4,200 Materials 6,400 Prepaid Expenses 600 Plant and Equipment 82.000 Accumulated DepreciationPlant and Equipment 32,000 Accounts Payable 14.800 Common Stock. 1.50 par 30,000 Retained Earnings 83,100 159,900 159,900 Factory output and sales for 20Y8 are expected to total 3,800 units of product, which are to be sold at 120 per unit. The quantities and costs of the inventories at December 31, 20Y8, are expected to remain unchanged from the balances at the beginning of the year. Budget estimates of manufacturing costs and operating expenses for the year are summarized as follows: Estimated Costs and Expenses Fixed Variable (Total for Year) (Per Unit Sold) Cost of goods manufactured and sold: Direct materials 30.00 Direct labor B.40 Factory overhead: Depreciation of plant and equipment 4,000 Other factory overhead 1,400 4.30 Selling expenses: Sales salaries and commissions 12,800 13.50 Advertising 13,200 Miscellaneous selling expense 1,000 2.50 Administrative expenses: Office and officers salaries 7,800 7.00 Supplies 500 1.20 Miscellaneous administrative expense 400 2.40 Balances of accounts receivable, prepaid expenses, and accounts payable at the end of the year are not expected to differ significantly from the beginning balances. Federal income tax of 35,000 on 20Y8 taxable income will be paid during 20Y8. Regular quarterly cash dividends of 0.20 per share are expected to be declared and paid in March, June, September, and December on 20,000 shares of common stock outstanding. It is anticipated that fixed assets will be purchased for 22,000 cash in May. Instructions 1. Prepare a budgeted income statement for 20Y8. 2. Prepare a budgeted balance sheet as of December 31,20Y8, with supporting calculations.CASH BUDGETING Helen Bowers, owner of Helens Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2015 and 2016: May 2015 180,000 June 180,000 July 360,000 August 540,000 September 720,000 October 360,000 November 360,000 December 90,000 January 2016 180,000 Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale, 75%; collected the second month following the sale, 15%. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus raw materials: May 2015 90,000 June 90,000 July 126,000 August 882,000 September 306,000 October 234,000 November 162,000 December 90,000 General and administrative salaries are approximately 27,000 a month. Lease payments under long-term leases are 9,000 a month. Depreciation charges are 36,000 a month. Miscellaneous expenses are 2,700 a month. Income tax payments of 63,000 are due in September and December. A progress payment of 180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be 132,000, and a minimum cash balance of 90,000 should be maintained throughout the cash budget period. a. Prepare a monthly cash budget for the last 6 months of 2015. b. Prepare monthly estimates of the required financing or excess fundsthat is, the amount of money Bowers will need to borrow or will have available to invest. c. Now suppose receipts from sales come in uniformly during the month (that is, cash receipts come in at the rate of 1 30 each day), but all outflows must be paid on the 5th. Will this affect the cash budget? That is, will the cash budget you prepared be valid under these assumptions? If not, what could be done to make a valid estimate of the peak financing requirements? No calculations are required, although if you prefer, you can use calculations to illustrate the effects. d. Bowers sales are seasonal; and her company produces on a seasonal basis, just ahead of sales. Without making any calculations, discuss how the companys current and debt ratios would vary during the year if all financial requirements were met with short-term bank loans. Could changes in these ratios affect the firms ability to obtain bank credit? Explain.
- CASH BUDGETING Helen Bowers, owner of Helens Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2014 and 2015: May 2014 180,000 June 180,000 July 360,000 August 540,000 September 720,000 October 360.000 November 360,000 December 90,000 January 2015 180.000 Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale, 75%; collected the second month following the sale, 15%. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus raw materials: May 2014 90,000 June 90,000 July 126,000 August 882.000 September 306,000 October 234,000 November 162,000 December 90,000 General and administrative salaries are approximately 27,000 a month. Lease payments under long-term leases are 9,000 a month. Depreciation charges are 36,000 a month. Miscellaneous expenses arc S2,700 a month. Income tax payments of 63,000 arc due in September and December. A progress payment of 180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be 132,000, and a minimum cash balance of 90,000 should be maintained throughout the cash budget period. a. Prepare a monthly cash budget for the last 6 months of 2014. b. Prepare monthly estimates of the required financing or excess funds that is, the amount of money Bowers will need to borrow or will have available to invest. c. Now suppose receipts from sales come in uniformly during the month (that is, cash receipts come in at the rate of 130 each day), but all outflows must be paid on the 5th. Will this affect the cash budget? That is, will the cash budget you prepared be valid under these assumptions? If not, what could be done to make a valid estimate of the peak financing requirements? No calculations are required, although if you prefer, you can use calculations to illustrate the effects. d. Bowers sales are seasonal; and her company produces on a seasonal basis, just ahead of sales. Without making any calculations, discuss how the companys current and debt ratios would vary during the year if all financial requirements were met with short-term bank loans. Could changes in these ratios affect the firms ability to obtain bank credit? Explain.Budgeted income statement and supporting budgets The, budget director of Feathered Friends Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for December 2016: a. Estimated .sales for December: Bird house 3,200 units at 50 per unit Bird feeder 3,000 units at 70 per unit b. Estimated inventories at December 1: Direct materials: Finished products: Wood 200 ft Bird house....... 320 units at 27 per unit Plastic 240 lbs. Bird feeder....... 270 units at 40 per unit c. Desired inventories at December 31: Direct materials: Finished products: Wood 220 ft Bird house....... 290 units at 27 per unit Plastic 200 lbs. Bird feeder....... 250 units at 41 per unit d. Direct materials used in production: In manufacture of Bird House: In manufacture of Bird Feeder: Wood 0.80 ft. per unit of product Wood........... 1.20 ft per unit of product Plastic 050 lb. per unit of product Plastic........... 0.75 lb. per unit of product e. Anticipated cost of purchases and beginning and ending inventory of direct materials: Wood 7.00 per ft. Plastic................. 1.00 per lb. f. Direct labor requirements: Bird House: Fabrication Department 0.20 hr. at 16 per hr. Assembly Department 0.30 hr. at 12 per hr. Bird Feeder: Fabrication Department 0.40 hr. at 16 per hr. Assembly Department 0.35 hr. at 12 per hr. g. Estimated factory overhead costs for December. Indirect factory wages 75,000 Power and light 6,000 Depreciation of plant and equipment 23,000 Insurance and property tax 5,000 h. Estimated operating expenses for December: Sales salaries expense 70,000 Advertising expense 18,000 Office salaries expense 21,000 Depreciation expenseoffice equipment 600 Telephone expenseselling 550 Telephone expenseadministrative 250 Travel expenseselling 4,000 Office supplies expense 200 Miscellaneous administrative expense 400 i. Estimated other income and expense for December: Interest revenue 200 Interest expense 122 j. Estimated lax rate: 30% Instructions 1. Prepare a sales budget for December. 2. Prepare a production budget for December. 3. Prepare a direct materials purchases budget for December. 4. Prepare a direct labor cost budget for December. 5. Prepare a factory overhead cost budget for December. 6. Prepare a cost of goods sold budget for December. Work in process at the beginning of December is estimated to be 29,000 and work in process at the end of December is estimated to be 35,400. 7. Prepare a selling and administrative expenses budget for December. 8. Prepare a budgeted income statement for December.
