Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I have A through M done. Just need help with the rest. Thank you. Commute Comprehensive Budget Project 2 Mueller's Backpacks Manufacturing Co. Mueller's Backpacks
I have A through M done. Just need help with the rest. Thank you.
Commute Comprehensive Budget Project 2 Mueller's Backpacks Manufacturing Co. Mueller's Backpacks Manufacturing Co. produces nylon backpacks and larger packs to sell to tourists visiting the Western United States and other tourist areas. The design of the two products is unique and represents a breakthrough in the industry. The company is completing its eighth year of operations and is preparing to build its master budget for the coming year, 2020. The budget will detail each quarter's activity and the activity for the year in total. The master budget will be based on the following information: A. Projected 2020 unit sales for each quarter and for the first two quarters of 2021 are as follows: Year 2020 2020 2021 2021 Backpacks Larger Backpacks Backpac 20,790 1 23,100 2 70 First Quarter 20,790 8,480 41,580 27,72 Third Quarter 32,340 13,860 Fourth Quarter 27,258 4,620 The selling price for the above quarters is projected at $$5.00 per smaller bags and S175.00 per larger bag. B. Shan 5,082 Mueller's carefully screens its customers and expects no uncollectable accounts. For budget purposes, each quarter has the following collection2 pattem: 10% of thetoaliscash sales40%arthe.total willbecolle telur. B in the quarter of sale, 50% of the total will be collected in the quarter following the sale. C. 2 -- O D. Muele's ended the current year C2o18) with a finished goods inventory of preea 25410 smaller bags and 13,860 larger hags. Because of a discouraging re economic forecast, it plans to budget an ending inventory o quarter's unit sales. The company's ending Work-in-Process inventory is xpected to be $127.050 (this number will only be used in the Cost of Goods 10obf the next Manufactured Statement and Balance Sheet). E. The following are the budgeted standard costs to make I finished product. Larger Backpacks Back Direct Material Nylon 330sq yd 510396yd. 1.375 sq, yd. 510.396 y Direct Labor Cutt 110 hr 275 hr @$20.79 hr.165 hr 34.65 hr. 44 hr a$20.79 hr @S34.65 hr Variable Per Travel Bag s3.58 Per larger bag @$3.58 Fixed Per travel@$2.356 ba Per larger bag @$2.356 cost the projected finished goods inventory on the Income Statement and Balance Sheet. F. The fixed overhead rate is based on a four year average and will be used only to G. Mueller's will start the budget year with 7.219 sq. yards of nylon and 8,689 Sq, yards of lining. For budgeting purposes, the plan is to always have an ending inventory of nylon equal to 30% of the next quarter's needs and lining equal to 25% of next quarter's needs. H. Mueller's buys raw material on account and plans to pay for 25%in the quarter of purchase and the remaining 759% in the next quarter. The accounts payable account consists only of the unpaid portion of the purchase of raw materials. I. Wages and salaries are paid on the last day of the month. Fixed overhead is projected as follows and is paid for in the quarter incurred (except for depreciation). J. Depreciation $20,790 per qtr. Property tax $4,274 per qtr Supervisory Salary $25,988 per qtr Insurance $1,444 per qtr. Variable overhead is budgeted as follows and is paid for in the quarter incurred. It is based on total units produced (small backpacks +larger backpacks) K. Indirect Materials $0.4851 per unit produced Indirect Labor $1.9173 per unit produced Maintenance $0.3696 per unit produced Utilities $0.8085 per unit produced L. Marketing expenses are as follows and are paid for in the quarter incurred. Advertising $25,988 per qtr Commissions 5.0% of dollar sales Salary $31,763 per qt M. Fixed administrative expenses are as follows and are paid for in the quarter incurred (except for depreciation). Depreciation-$1,444 per qtr. Officers' Salaries $25,988 per qtr Office Salaries $18,625 per qtr Office Rent- $2,490.47 per qtr Miscellaneous- $1,804.69 per qtr N. The Balance Sheet (unclassified) for the year just ending (2018) is as follows: Assets: Cash Accounts Receivable Finished Goods Inventory-smaller Finished Goods Inventory-larger Work-in-process Inventory Nylon Inventory Lining Inventory Property, plant, and equip. (net) 308,000 407,000 870,232 876,480 235,840 123,750 39,600 3,520,000 s 6,380,902 Total Assets Liabilities: $209,000 S 1,210,000 Accounts Payable Income Tax Payable Interest Payable Dividends Payable Short-term Debt Stockholders Equity $ 3,300,000 1,661,902 Total liabilities and Stockholder's Equity $ 6,380,902 O. In January Mueller's expects to declare a $240,000 dividend. Common Stock Retained Earnings It will be paid % in the second quarter and h in the fourth quarter. Mueller's also plans to purchase and pay for $125,000 of equipment during each quarter. P. Q. The income tax rate is 35% and is paid on April 15 of the next year. Required: Prepare the formal master budget schedules for each quarter of the coming year, 2020 and for the year in total. Prepare formal financial statements for the year only. The following components must be included: a. Sales budget 2 b. Production budget 3 c. Material purchases budget 4 d. Direct Labor budget e. Variable Overhead budget of. Fixed Overhead budget g. Marketing budget 8 h. General and Administration budget 9i. Cash budget cj. Schedule of Cost of Goods Manufactured (annual only) k. Classified Income Statement (annual only) z1. Retained Earnings Statement (annual only) n. Statement of Cash Flows- indirect method (annual only) m. Classified Balance Sheet (annual only) Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started