The requirements are to correctly budget the following (this is all the directions and information given). THIS IS ALL THE INFORMATION I WAS GIVEN.
Perky Turkey Jerky, LLC | ||||
Sales Budget | ||||
For the Quarter Ending June 30, 2018 | ||||
Month | Quarter Total | |||
April | May | June | ||
Budgeted Sales (in units) (a) | 10,000 | 12,000 | 15,000 | 37,000 |
Selling price per unit (b) | $9.00 | $9.00 | $9.00 | $9.00 |
Total Sales (a * b) | $90,000 | $108,000 | $135,000 | $333,000 |
Schedule of Expected Cash Collections | ||||
Month | Quarter Total | |||
April | May | June | ||
Beginning Accounts Receivable | $9,000 | $9,000 | ||
April Sales ($90,000*90/100); ($90,000*10/100) | $81,000 | $9,000 | $90,000 | |
May Sales ($108,000*90/100); ($108,000*10/100) | $97,200 | $10,800 | $108,000 | |
June Sales ($135,000*90/100); | $121,500 | $121,500 | ||
Total Cash Collections | $90,000 | $106,200 | $132,300 | $328,500 |
Perky Turkey Jerky, LLC | ||||
Production Budget | ||||
For the Quarter Ending June 30, 2018 | ||||
Month | Quarter Total | |||
April | May | June | ||
Budget Sales in Units | 10,000 | 12,000 | 15,000 | 37,000 |
Add: Desired Ending Inventory (12,000*20/100); (15,000*25/100); (15,000*30/100) | 2,400 | 3,750 | 4,500 | 10,650 |
Total units needed | 12,400 | 15,750 | 19,500 | 47,650 |
Less: Units of beginning finished goods (10,000*20/100) (last month's ending inventory will be the current month's beginning inventory) | 2,000 | 2,400 | 3,750 | 8,150 |
Required production in units | 10,400 | 13,350 | 15,750 | 39,500 |
Note: The third one is wrongly given as Sales Budget but it is Production Budget as the first one is the Sales Budget.
The requirements are to correctly budget the following (this is all the directions and information given)....
Use the following table to complete the budget sheet. Please help me solve this question, thank you!!! Balance Sheet March 31, 2018 Assets 52,000.00 9,000.00 2,750.00 14,300.00 Current Assets Cash Accounts Receivable Raw Materials Inventory (1,100 pounds) Finished Goods Inventory (2,000 units) Total Current Assets Plant and Equipment Equipment Accumulated Depreciation Plant and Equipment, Net Total Assets 78,050.00 930,000.00 (63,000.00) 867,000.00 945,050.00 7,500.00 100,000.00 Liabilities and Stockholders' Equity Liabilities Accounts Payable Bonds Payable Stockholders' Equity Common Stock 800,000.00 Retained Earnings...
Please use the beginning balance sheet and Budgeting Assumptions to complete the cash budget and budgeted income statement. Thank you! Balance Sheet March 31, 2018 Assets Current Assets Cash 52,000.00 Accounts Receivable 9,000.00 Raw Materials Inventory (1,100 pounds) Finished Goods Inventory (2,000 units) 2,750.00 14,300.00 Total Current Assets 78,050.00 Plant and Equipment Equipment 930,000.00 Accumulated Depreciation Plant and Equipment, Net (63,000.00) 867,000.00 Total Assets 945,050.00 Liabilities and Stockholders' Equity Liabilities Accounts Payable 7,500.00 Bonds Payable 100,000.00 Stockholders' Equity Common Stock...
Prepare a production budget and a direct manufacturing labor cost budget for PetersonPeterson Company by month and for the first quarter of 20182018. You may combine both budgets in one schedule. The direct manufacturing labor cost budget should include labor-hours and show the details for each labor cost category. Start the schedule by preparing the production budget and calculating the total hours of direct manufacturing labor time needed for the three months in the quarter, then calculate the values for...
Please prepare a production budget with the following master budget information: Projected unit sales for each quarter for 2013 are as follows: Quarter 1 60,000 Quarter 2 70,000 Quarter 3 80,000 Quarter 4 65,000 The selling price is $500 per unit. All sales are on credit (no cash sales). 70% of all sales are collected within the quarter they are sold. The other 30% are collected in the following quarter. There are no bad debts. There is no beginning inventory...
Prepare a production budget and a direct manufacturing labor cost budget for PetersonPeterson Company by month and for the first quarter of 20182018. You may combine both budgets in one schedule. The direct manufacturing labor cost budget should include labor-hours and show the details for each labor cost category. Start the schedule by preparing the production budget and calculating the total hours of direct manufacturing labor time needed for the three months in the quarter, then calculate the values for...
Required information [The following information applies to the questions displayed below.] The management of Zigby Manufacturing prepared the following estimated balance sheet for March, 2013: ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2013 Assets Cash $ 48,000 Accounts receivable 438,750 Raw materials inventory 87,900 Finished goods inventory 383,760 Total current assets 958,410 Equipment, gross 616,000 Accumulated depreciation (158,000) Equipment, net 458,000 Total assets $ 1,416,410 Liabilities and Equity Accounts payable 187,200 Short-term notes...
Problem 20-4A Manufacturing: Preparation of a complete master budget LO P1, P2, P3 The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2017: ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2017 Assets Cash Accounts receivable Raw materials inventory Finished goods inventory Total current assets Equipment, gross Accumulated depreciation Equipment, net Total assets Liabilities and Equity Accounts payable Short-term notes payable Total current liabilities Long-term note payable Total liabilities Common stock Retained earnings Total stockholders' equity Total...
The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2017: ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2017 Assets Cash $ 53,000 Accounts receivable 392,400 Raw materials inventory 96,600 Finished goods inventory 313,920 Total current assets 855,920 Equipment, gross 626,000 Accumulated depreciation (163,000 ) Equipment, net 463,000 Total assets $ 1,318,920 Liabilities and Equity Accounts payable $ 204,800 Short-term notes payable 25,000 Total current liabilities 229,800 Long-term note payable 520,000 Total liabilities 749,800 Common stock 348,000...
Problem 22-4A Manufacturing: Preparation of a complete master budget LO P1, P2, P3 The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2017: ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2017 Assets $ Cash 46,000 Accounts receivable 386,925 96,290 327,831 Raw materials inventory Finished goods inventory Total current assets 857,046 Equipment, gross Accumulated depreciation Equipment, net 612,000 (156,000) 456,000 $1,313,046 Total assets Liabilities and Equity 196,190 18,000 214,190 Accounts payable Short-term notes payable $ Total current...
company is preparing its budget for 2019. the company has collected the following information from the managers. 1. sales: sales for November 2018 112,500 units sales for the December 2018 102,100 units Expected sales for January 2019 113,000 units Expected sales for February 2019 112,500 units Expected sales for March 2019 116,000 units Expected sales for April 2019 125,000 units Expected sales for May 2019 137,500 units Selling price unit $12 The company likes to keep 15% of next months...