the fkrst picture is the data given and the second is everything that needs to be done

Project Data 1. Frame inc manufactures bamboo picture frames that sell foe $25 each. Each frame requires 4 feet of bamboo, which costs $2.00 per foot. Each frame takes approximately 30 minutes to build, and the labor rate averages $14 per hour. I-Frame has the following irventory policies - Ending finished goods imventory should be 40% of next month's sales. - Ending direct materials imentory should be 30% of next month's production. Expected anit salus (frames) for the upcoming months followi Variable manufacturing overhead is incurred at a rate of $0.40 per unit produced. Annual foced manufacturing overhesd is estimated to be $8,400 i $700 per month) for expected production of 4,000 units for the vear. The budgeted manulacturing cost per unit is $17.50. In addition, selling and administrative expenses are estimited at $750 per month plus $0.50 per unit sold. Of its sales, 8006 is in cash and 2006 is on credit. Of the credit sales, 5006 is collected during the same month of the sale, and 50% is collected during the month following the sale. Of direct materials purchases, 80% is paid for during the month purchased and 20% is paid in the following month. Direct inateriats purchases for March 1 totaled $2,800. Af other operating costs are paid during the month incured. Monthly foed manufacturing ovemead includes $260 in depreciation During Apal. I. Frame plans to pay $2.500 for a piece of equipment. Iframe had $13,500 cash on hand on April 1. Assume the company can borrow interest-free in increments of $1.000 to inaintain a $13,000 ininimuts endiog casti balance. Repayments are made in the following month, assuming sufficient cash is avallable. (For example, if vou need $4,300 at the end of April to meet your desired endting cash bilance you would borrow $5,000 in April. and repay the $5,000 in May). 1. Sales Budget; 2. Production Budget; 3. Direct Materials Budget; 4. Direct Labor Budget; 5. Manufacturing Overhead Budget; 6. COGS Budget; 7. Selling, General \& Administrative Expenses Budget; 8. Budgeted Income Statement: 9. Cash Receipts Budget: 10. Cash Payments Budget; 11. Summary Cash Budget Final Deliverables