Prepare the budgeted schedules

Cellmor Products Is preparing its budget for January, February and March 2021, and has collected and assembled the following Information and assumptions for its Income statement and cash flow budgets: 49 50 Budgeted Sales and Cost of Goods Sold Fatruary March April Unit Sales 3 500 3010 4,200 3.200 54 Sailing Price, par writ $30 00 $31/00 $32 00 so Cost of Goods Sold, per unit 17:00 17.00 1700 17100 56 58 Budgeted monthly operating expenses Salaries Expertes $15000 pa math Other Fiand Experises $10 000 per month Depreciation Experise 52040 per marth Variable Selling Expense 15% d in mont's pies $ 67 Cash collections of Sales Revenue: 64 Accounts Receivable Balances, December 31, 2019 $70,000 (all of which is to be collected in January) 6 Peroutage of Sales elected in month of sale 45% 70 Perombags of Sales colledied in month following the sale 55% 71 Ta 73 Cash payments on Cost of Goods Sold: TA Accounts Payable balance, December 31, 2019 $45,000 (allof which is to be paid in January 73 Percentage of COGS paid for in mom ingarted 25% d COGS The Peromay al COGS paid far In fallowing mann 75% a COGS 18 Cash payments on operating expenses Paid for im application in te man imrred 30 Other cash flow info: 21 Cash dividends pad part marin 12000 par main all Equipment purchase to cash 41200 in January Equipment purchine la cash Hom InFebruary Operating Line of Credit: Minimun ed ol mont cash balance daired $15.000 Pad when principle in road Arria Internal on barowed can Any amounts bonowed are borrowed at the bocainning of the month where bonowing h needed Any bank loan amounts |and interest repa'i are roped at the ead of the month