Using the data below, can someone help me set up (and solve) the MOH, COGS, and Operating Expense Budget
Yukon, LLC, in Thibodaux, LA, makes a smoked jerky snack, Nutria Snack Stix. Yukon buys nutria from local trappers and prepares the jerky by seasoning the meat in a marinate for 24 hours, then smoking it for 4 hours before letting it cool and packaging it for sale. The snacks sell in random weight packages for $1.50 per oz ($24/1b). The company is preparing its master budget for the first quarter and has presented you with the following information. 1. The Accounts Receivable balance at December 31st represents the remaining balances of November and December sales: 5,000 and 6,000 lbs, respectively. 2. Estimated sales in pounds of jerky for January through May follow: January 8,000 February 9,000 March 9,500 April 9,500 May 11,000 3. The collection pattern for accounts receivable is as follows: 75% in the month of sale, . 20% the month after sale, and . 5% the second month after sale. Yukon expects no bad debts and gives no cash discounts. 4. Each pound of jerky has the following standard quantities and costs for direct materials and direct labor: Nutria (DM) Quantity Cost/rate Sid Cost 2.20 lbs $1.00 $2.20 Seasoning (DM) 0.10 1bs $15.00 $1.50 Direct labor 0.60 hrs $14-50 $8.70 Some loss occurs during processing (bones, fat, etc.). Variable overhead (VOH) is applied basis smoker-hours (SH). The processing of 100 lbs of jerky takes 4 SH. The estimated cost per smoker hour is $30 (VOH is composed of pit master costs and wood for the smoker). FOH is applied per pound based on an expected annual capacity of 120,000 pounds. Fixed overhead is incurred evenly throughout the year. Fixed overhead per year is composed of the following costs: Salaries $60,000 Utilities 28,800 Insurance-factory 8,200 Depreciation-factory 53,000 5. There is no beginning work in process inventory. All work in process is completed in the period in which it is started. Raw materials inventory at the beginning of the year consists of 2,500 pounds of Nutria and 750 pounds of seasoning. There are 2,000 pounds of jerky in finished goods inventory at the beginning of the year carried at standard cost. 6. Accounts Payable relates solely to raw material and is paid 80 percent in the month of purchase and 20 percent in the month after purchase. No discounts are given for prompt payment.7. The dividend will be paid in February. S. A new smoker costing $11,000 will be purchased in March and placed in use April 1. Payment of 60 percent will be made in March and 40 percent in April. The equipment has a useful life of 5 years and will have no salvage value. 9. The note payable has a 6% interest rate; interest is paid at the end of each month. The principal of the note is repaid in $1,000 increments as cash is available to do so. 10. Yukon's management has set a minimum cash balance at $10,000**. Line of credit loans are made in $1000 increments and repaid as cash is available (the interest rate is 6%). Assume all borrowing is done on the first day of the month and repaid on the last day when funds are available. (Assume interest has been paid on both the Note Payable and credit line through 12/31) 11. The ending finished goods inventory should include 30 percent of the next month's needs. This is not true at the beginning of January due to a miscalculation in sales for December. The ending inventory of raw materials should be 40 percent of the next month's needs. 12. Monthly selling and administrative costs are paid in cash. Per month costs are as follows: Salaries $10,000 Utilities 800 Office Rent 3,500 13. The December 31, 2019, balance sheet (partial) for the company follows. Yukon, LLC Balance Sheet December 31, 2019 Assets Liabilities and Stockholder Equity Cash ** $5,080 Accounts Payable $18,975 Accounts Receivable 42,000 Notes Payable 25,000 Raw Materials Inventory 13,750 Dividends Payable 20.000 Finished Goods Inventory 29,700 Total Liabilities 63,975 Prepaid Insurance 4,100 Common Stock 100,000 Building 375,000 Paid-in Capital 20,000 Acc Depreciation (85,000) ** the cash balance requirement becomes effective Jan 1, 2020 Required: Prepare a master budget including all appropriate schedules, by month, for the first quarter, including quarterly totals and the pro- forma income statement and balance sheet as of March 31st