50.1K

Verified Solution

Link Copied!

Hello! I am needing a master budget created of the following question! The last 4 pictures are the answers I will be needing! Need done asap!!! Thank you

Innovate Company is a highly-progressive organization that produces Netbook computers. The design of Innovate's system is unique and represents the latest breakthrough in touch-screen portable computers. The company is preparing to build its master budget for the coming year (20XX). The annual budget is segmented into detail for each quarter's activity and for the year in total. The master budget will be based on the following Information: a. Fourth quarter sales from the prior year are 5,500 units. b. Unit sales by quarter (for 20X) are projected as follows: First quarter 6,000 Second quarter 8,000 Third quarter 8,000 Fourth quarter 9,000 The selling price is $650 per unit. All sales are on credit. Innovate collects 85 percent of all sales within the quarter in which they are realized; the other 15 percent are collected in the following quarter. Innovate will start recording bad debt expense this year. The company estimates that 1 percent of the balance of accounts receivable will be uncollected and will make an adjustment entry at the end of the year (le will not affect the cash account for the current year, but it will affect certain Income statement and balance sheet accounts). c There is no beginning inventory of finished goods. Innovate is planning the following ending finished goods inventories for the quarter. I First quarter 1,300 units Second quarter 1,500 units Third quarter 2,000 units Fourth quarter 1,000 units d. Innovate leases machines used in production. Per terms of the capital lease, the company has the right to use the machines, but must pay maintenance on the machines. At current capacity, Innovate's expense due to leasing will be $640,000 per quarter. The foxed utility cost is $60,000 per quarter and the salaries of factory supervisors and staff will be $300,000 per quarter. e. Variable overhead consists primarily of machine maintenance and the costs incurred to run the machines. From past experience, Innovate estimates machine maintenance expense to be $1 per direct labor hour (DLH) and the cost of utilities and labor to run the machines is $5 per DLH. Overhead is allocated based on direct labor hours used in production. All overhead expenses are paid for in the quarter incurred. f. The selling and administrative staff is based in a separate building from where the Netbook computers are produced. Rent expense for the administrative building is $40,000 per month, the fixed portions of telephone and utility expenses averages $20,000 per month, and the fixed fee for technical support is $20,000 every three months. Depreciation expense is $50,000 per quarter. $28.979.800 & Variable selling and administration expenses consist of billing expenses of $1 per unit sold, sales commissions $7 per unit, and the variable portion of telephone and utility expenses is $2 per unit sold. All selling and administrative expenses are paid for in the quarter incurred. h. Each Netbook computer unit assembly require five hours of direct labor and three items of direct materials. Workers are paid $10 per hour, and although the items of direct materials are different (case, motherboard, and peripheral package), each item of materials average cost is $80. There are 6,570 items of direct materials in beginning Inventory as of January 1, 20XX. At the end of each quarter, Innovate plans to have 20 percent of the direct materials needed for next quarter's unit sales. Innovate will end the year with the same level of direct materials found in this year's beginning Inventory. Innovate buys direct materials on account. One-half of the purchases are paid for in the quarter of acqulsition, and the remaining half is pald for in the following quarter. Direct labor wages are paid on the fifteenth and thirtieth of each month. k The trial-balance as of December 31, of the prlor year is as follows: Assets Cash $ 607,000 Inventory 525,600 Accounts receivable 536,250 Plant and equipment 27.310.950 Total Assets Labilities and Equity Accounts payable 1 $ 724,800 Capital stock 20,197,000 Retained earnings 8.058.000 Total liabilities and equity $28.979.800 Innovate will pay dividends of $50,000 in the first and third quarter. At the end of the fourth quarter, $2 million of equipment will be purchased. REQUIRED: Prepare a master budget for Innovate Company for each quarter of 203X and for the year in total. The following component budgets must be included: a. Sales budget b. Production budget c Direct materials purchases budget d. Direct labor budget e Overhead budget t. Selling and administration expense budget & Ending finished goods Inventory budget h. Costs of goods sold budget 1. Cash budget Proforma Income statement (using absorption costing) k Pro forma balance sheet Innovate Company Schedule 1: Sales Budget For Year Ended December 31, 20XX Qtt1 Qtt 2 Otr. 3 Otr 4 Year Sales in Units *Unit Price Total Sales Revenue Innovate Company Schedule 2: Production Budget For Year Ended December 31, 20XX Qtr 2 Otr3 Qr4 Year Sales (in units) Add: Desired ending Inventory Total needs Less: Beginning inventory Required Production (in units) Innovate Company Schedule 3: Direct Materials Budget For Yelr Ended December 31, 20xx Qtr 1 Otr2 Otr3 Qtr 4 Year Production (in units) * Materials/unit Production needs Add: Desired ending Inventory Total needs Less: Beginning inventory Required Purchases x Cost per unit Cost of Purchases Innovate Company Schedule 4: Direct Labor Budget For Year Ended December 31, 2oxx Ott 2 Ott 3 atte Year Production (in units) x Hours per unit Hours needed x Cost per hour Total Direct Labor Cost Innovate Company Schedule 5: Overhead Budget For Year Ended December 31, 20% Ott 2 Otr3 atre Year Budgeted hours xVariable OH Rate Total Budgeted Variable OH Cost Budgeted Fixed OH Cost: Lease Expense Uulity Expense Salaries Expense Total Budgeted Fred OH Cost Total OH Cost Otr4 Year Innovate Company Schedule 6: Selling & Administration Expense Budget For Year Ended December 31, 2004 Qtc2 Otr3 Sales (in units) *Variable Selling & Admin. Rate Total Variable S. & A Expense Total Fixed S. & A. Expense Total Selling & Admin. Expense Innovate Company Schedule 7: Ending Finished Goods Inventory Budget For Year Ended December 31, 2030% Unit cost comparison Direct materials (3 units @ $80) Direct labor (5 hours $10) Overhead: Variable (s DLH @ $6/DLH) Faed (SDLH @ ?/DLH) Total unit cost Units Cost per un Total Amount Finished Goods: Innovate Company Schedule 8: Cost of Goods Sold Budget For Year Ended December 31, 20xx Direct materials used (sch 3) Direct labor used (Sch 4) Overhead (Sch 5) Budgeted manufacturing cost Add: Beginning finished goods Goods available for sale Less: Ending finished goods (sch 7) Budgeted cost of goods sold Innovate Company Cash Budget For Year Ended December 31, 20XX ate 2 atr2 Otr 3 I Qtr 4 Year Beginning cash bal. Add Collections: Credit Sales: Current quarter Prior quarter Total cash avallable Less Disbursements: Direct Materials: Current quarter Prior quarter Direct labor Overhead Selling and admin. Dividends Equipment Total cash needs Ending cash balance Innovate Company Pro Forma Income Statement For Year Ended December 31, 20XX Sales (Sch 1) Less: Cost of Goods Sold (sch B) Gross Margin Less: Selling & Admin expenses (Sch 6) Bad Debt Expense Operating income before taxes Innovate Company Pro Forma Balance Sheet At Year Ended December 31, 20XX Assets: Cash Accounts Receivable Less: Allowance for Doubtful Accounts Inventory: Direct Materials Finished Goods Plant and equipment Total Assets Uabilities and Equity: Current Liabilities: Accounts Payable Stockholder's Equity Capital Stock Retained Earnings Total Liabilities and Equity Calculations: Beginning P&E Add: New Equipment Less: Depreciation Expense Ending P&E | to | | | Beginning RE Add: Net Income Less: Dividends Pald Ending RE

Answer & Explanation Solved by verified expert

See Answer