Problem 5 Prepare a cash budget by month for the month quarter ending September 30, 2009, from the following data obtained from the Peninsula Co. Support your solution with schedules of estimated receipts & payments. July P 12,000 September P 18,000 120,000 August P 16,000 Cash sales Credit sales Purchases Operating Expenses 15,000 Interest expense 110,000 150,000 120,000 18,000 2,000 90,000 110,000 16,000 Credit are collected 50% in the month of sales. 40% in the month following, 8% in the second month following and 2% uncollectible. Credit sales for May and June are expected to be P100,000 and P90,000 respectively. Purchases of merchandise, all on account are paid 60% in the month of purchase and 40% in the month following. Purchase for June are estimated at 80,000 are paid in the month incurred. Cash balance on June 30, 2009 is P27,000.
Q: QUESTION 19 William's Watches sold goods to Colin's Clocks for $1,980 including GST. Colin's Clocks…
A: Introduction:- The following basic information as follows under:- Journal entry is used to record…
Q: A company factored $45,000 of its accounts receivable and was charged a 4% factoring fee. The…
A: Cash received from factors = Accounts receivable transferred - factoring fees where, Factoring fees…
Q: determining changes to a partner's outside basis, which of the following statements is false? estion…
A: There are two basis Inside basis which is for partnership firm Outside basis is for partners.
Q: Jain Enterprises honors a short-term note payable. Principal on the note is $425,000, with an annual…
A: Introduction: Journals: Recording of a business transactions in a chronological order. Each and…
Q: SkyChefs, Inc., prepares in-flight meals for a number of major airlines. One of the company's…
A: Formulas: Labor spending variance = Standard Labor cost - Actual Labor cost Labor rate variance =…
Q: The difference between a merchant wholesaler and an agent/broker is based on the type of goods they…
A: Solution: A merchant wholesaler buys the goods from manufacturer and sell it to retailer.…
Q: Dividends of $1,000 is paid in cash to the stockholder of Pizza Inc. The general ledger account…
A: Dividend is the distribution out of net income to the stockholders of a company.
Q: Production Budget FlashKick Company manufactures and sells soccer balls for teams of children in…
A: The production budget is prepared to estimate the number of units to be produced during the period.
Q: Logistics Solutions provides order fulfillment services for dot.com merchants. The company maintains…
A: Answer 1) Calculation of Standard labor hours allowed to ship 205,000 items Standard labor hours…
Q: A corporation commences operations on January 1, 2019. It has the following account balances at…
A: Introduction: Net Assets: Any Asset having economic resource called as Assets. Assets are of two…
Q: A customer was unable to pay the accounts receivable on time in the amount of $34,000. The customer…
A: Introduction: Journals: Each and every business transactions are to be recorded in Journals.…
Q: As per APES 110, an auditor may not: Select one: perform advisory services for any audit client be a…
A: Concept of Profession ethics of professional accountant as per AEPS 110
Q: m price ag divis Requirements 1. What is the minimum price at which the airbag division woul 2.…
A: Incremental cost refers to the aggregate cost which is incurred because of extra unit of the product…
Q: Explain two main reasons why expenses may not be deductible for income tax/corporation tax purposes
A: Deductible expenses: These include all the expenses that are allowed to be deducted from the gross…
Q: At December 31, Folgeys Coffee Company reports the following results for its calendar year. Cash…
A: Formula: Bad debts expense (sales method) = Sales x uncollectible % Bad debts expense (Accounts…
Q: On January 1, 2017, Naruto Company issued P4,000,000 face value bonds with a stated rate of 12% and…
A: In the given case bonds are issued at discount. Interest expense to be reported in 2017 will be the…
Q: Match the following with the best mode of entry Fashion Label [Choose ] + Fast Food Operator [Choose…
A: Basic concept of Accounts and business
Q: On November 1, 2021, Jamison Inc. adopted a plan to discontinue its barge division, which qualifies…
A: Introduction:- Discontinued operations means parts of a company's business operations have been…
Q: Use the table below to answer questions about Christina's Christmas Wreaths. Christina operates in a…
A: Economic profit is comparable to accounting profit, but it takes into account opportunity costs as…
Q: 1. Question Content Area Sales Budget FlashKick Company manufactures and sells soccer balls for…
A: Budgeting is an important tool for the cost managers of an entity it helps to forecast the…
Q: . Prepare a merchandise purchases budget in bottles of vitamins for as many months as you can. Tiger…
A: A purchase budget is a budget prepared at the beginning of the period that involves the purchase…
Q: Find the capital beginning when, Additional Income = 150,000.00 Net Income = 120,000.00
A: Introduction: Capital: Capital is the owners contribution. capital has always credit balance.
Q: Exercise 9-4 Direct Materials Variances [LO9-4] Bandar Industries Berhad of Malaysia manufactures…
A: Answer 1) Calculation of Standard quantity of kilograms of plastic allowed to make 3,600 helmets…
Q: Operating Budget, Comprehensive Analysis Ponderosa, Inc., produces wiring harness assemblies used…
A: A budget is a forecast of revenue and expenses for a certain future period of time that is generally…
Q: Explanation it correctly Q)Which of the following interest rates is usually the highest? Multiple…
A: Interest rate is amount charged by lender which can either be banks, sellers, government, agencies…
Q: Compute the monthly payments on a 4-year lease for a $25,254 car if the annual rate df depreciation…
A: The question is based on the concept of Financial Management. Annuity refers to the series of equal…
Q: Ramirez Company installs a computerized manufacturing machine in its factory at the beginning of the…
A: Lets understand the basics. Depreciation is a reduction in value of asset due to wear and tear,…
Q: Two weeks after Royalty Corp was formed Juan sells the 30% of Royalty stock to the second party who…
A: The answer for the multiple choice question and relevant explanation are presented hereunder : Juan…
Q: A company’s flexible budget for 19,000 units of production showed sales, $87,400; variable costs,…
A: Introduction:- The flexible budget is planned to change based on the level of units volume. It is…
Q: Question 25 The year end of a corporation is: O Always at December 31 At the end of a 12 month…
A: corporation is generally a legal entity whose function has separate from its owner.corporation get…
Q: A company’s flexible budget for 16,000 units of production showed sales, $96,000; variable costs,…
A: A fixed cost is one who doesn't change in response to activities. It must be paid on a recurring…
Q: Required: Prepare a monthly operating budget for the first quarter with the following schedules: 1.…
A: Sales Budget refers to Expected Sales to be made in Upcoming period on the basis of expected selling…
Q: Profitability Ratios The following information has been gathered for Malette Manufacturing: Net…
A: Solution:- 1)Computation of the return on assets as follows under:- It measures a company's…
Q: Holiday Corp. has two divisions, Quail and Marlin. Quail produces a widget that Marlin could use in…
A: If widgets are produced in the excess capacity, only variable cost is relevant because fixed cost do…
Q: P9-4B (L05) (Gross Profit Method) Higgs Company lost most of its inventory in a fire in November…
A: The retail inventory technique is an accounting approach for estimating the worth of products in a…
Q: A corporation has the following account balances on December 31, 2019: Accounts 4,200 receivable…
A: Introduction: Income statement: All revenues and expenses are to be shown in income statement. It…
Q: Assume a company has only one service department and one operating department. The service…
A: The overhead cost will be allocated to actual production on the basis of actual number of units…
Q: Hanging Valley plc has issued share price of 2m ordinary shares, nominal value £1. The board of the…
A: Theoretical Ex Right price means price per share after the issue of right ordinary shares. Formula :…
Q: Leverage Ratios Grammatico Company has just completed its third year of operations. The income…
A: Solution:- Leverage Ratios identify the ability of a company to meet its financial obligations.…
Q: The standard cost of product 777 includes 2.1 units of direct materials at $6.00 per unit. During…
A: Materials price variance = (Standard price - Actual price) x Actual quantity Materials quantity…
Q: Part A Phelps Corporation has two classes of share capital outstanding: $5 par ordinary and $20 par…
A: Company means the form of business where the owner are allotted shares. Journal entry means the book…
Q: An entity sells inventory with a list price of P10,000 under credit terms of 20%, 10%, 2/15, n/30.…
A: Accounts receivable is the amount receivable from the customers upon credit sales. Companies will…
Q: Shue, a partner in the Financial Brokers Partnership, has a 30 percent share in partnership profits…
A: Net Income of the partnership is calculated by subtracting total expenses from total revenues.…
Q: Bannister Motors Corporation reported the following var
A: Variance manages the cost gauge of the project. It furnishes you with data about whether you are an…
Q: Under the indirect method of determining net cash provided by operating activities on the statement…
A: A decrease in accounts receivable: Added An increase in accrued liabilities: Added A decrease in…
Q: Define the following concepts: a)Prime cost b) Non production cost c)Total cost
A: The term cost refers to the monetary value of expenditure for raw materials, technology, supplies,…
Q: 1. Acer Computer Services is owned by Pepito Manoloto. Prepare the Balance Sheet of the business.…
A: Since, basic accounting equation is Total assets = Total liabilities + owners equity
Q: Question 5 To determine the scope of a bookkeeping clean-up engagement, you are reviewing the Client…
A: The Shareholder Equity of a corporation is shown on the balance sheet below the Liabilities section.…
Q: Find the capital beginning when, Additional Income = 150,000.00 Net Income = 120,000.00 Withdrawal =…
A: Capital Beginning = Capital Ending + Withdrawal - Additional income - Net income
Q: 1
A: The sharing of profit and loss in accordance with the profit and loss sharing ratio.it completely…
Variance Analysis
In layman's terms, variance analysis is an analysis of a difference between planned and actual behavior. Variance analysis is mainly used by the companies to maintain a control over a business. After analyzing differences, companies find the reasons for the variance so that the necessary steps should be taken to correct that variance.
Standard Costing
The standard cost system is the expected cost per unit product manufactured and it helps in estimating the deviations and controlling them as well as fixing the selling price of the product. For example, it helps to plan the cost for the coming year on the various expenses.
Step by step
Solved in 2 steps
- A. Discuss the purpose of the cash budget. B. If the cash for the first quarter of the fiscal year indicates excess cash at the end of each of the first two months, how might the excess cash be used?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.Forecast sales volume and sales budget Sentinel systems Inc. prepared the following sales budget for 20Y8: At the end of December 20Y8, the following unit sales data were reported for the year: Unit Sales Home Alert System Business Alert System United States 1,734 1,078 Europe 609 329 Asia 432 252 For the year ending December 31, 20Y9, unit sales are expected to follow the patterns established during the year ending October 31, 20Y8. 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 increased 820, effective January 1, 20Y9. Instructions 1. Compute the increase or decrease.ase of actual unit sales for the year ended October 31, 20Y8, 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 20Y9, compute the unit sales volume to be used for preparing the sales budget for the year ending December 31, 20Y9. 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. 20Y8 Percentage 20Y9 Actual Increase Budgeted Units (Decrease) Units (rounded) 3. Prepare a sales budget for the year ending December 31, 201Y9
- a. Discuss the purpose of the cash budget. b. If the cash for the first quarter of the fiscal year indicates excess cash at the end of each of the first two months, how might the excess cash be used?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.Forecast sates volume and sales budget For 20Y8, Raphael Frame Company prepared the sales budget that follows. At the end of December 20Y8, 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, 20Y9, unit sales are expected to Follow the patterns established during the year ending December 31, 20Y8. The unit selling price for the 8" 10" the frame is expected to Increase to 17 and the unit selling price for the 12" 16" frame is expected to increase to 32, effective January 1, 20Y9. Instructions 1. Compute the increase or decrease of actual unit sales for the year ended December 31,. 20Y8, 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 20Y9, compute the unit sales volume to lie used for preparing the sales budget for the year ending December 31, 20Y9. 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. 20Y8 Percentage 20Y9 Actual Increase Budgeted Units (Decrease) Units (rounded) 3. Prepare a sales budget for the year ending December 51. 20Y9.
- 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.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.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, 20Y9, the following tentative trial balance as of December 31, 20Y8, is prepared by the Accounting Department of Mesa Publishing Co.: Cash. 26,000 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 20Y9 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, 20Y9, 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....................................... 840 Factory overhead: Depreciation of plant and equipment............ 4,000 Other factory overhead......................... 1,400 4.80 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 20Y9 taxable income will be paid during 20Y9. 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 20Y9. 2. Prepare a budgeted balance sheet as of December 31, 20Y9, with supporting calculations.
- Budgeted income statement and balance sheet As a preliminary to requesting budget estimates of sales, costs, and expenses for the fiscal year beginning January I, 20Y9, the following tentative trial balance as of December 31, 20Y8, 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 DepreciationPlant 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 20Y9 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, 20Y9, 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.................................. 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, anti 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 20Y9 taxable income will be paid during 20Y9. 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 20Y9. 2. Prepare a budgeted balance sheet as of December 31, 20Y9, with supporting calculations.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.