Use the following assumptions in making your budget calculations:

a. Assume all 12 months have 30 days to make the calculations easier. This is commonly done in the business world.

b. Projected sales in units are 1656 in January and increase by 265 units each month through the remainder of the year.

c. Sales price includes COST PLUS AN ADDITIONAL 150% OF COST (cost includes raw material, direct labor and overhead). All sales are on account and are collected 35% in the month of sale, 35% in the next month, and 20% in the second following month. The remaining accounts receivable are uncollectible and recorded as bad debt expense IN THE MONTH OF SALE.

d. Production Tab only: The company wants to have at least 30% of the next months projected sales in ending finished goods inventory on hand. (Since the company is just starting, beginning January finished good will be zero.)

e. Direct Materials Tab only: At the start of each month, management plans to have enough packets of raw materials on hand to cover the next 30 days production requirements. Each packet of raw material costs $134.00. The company will have 2245 packets on hand on January 1, 20xx. ALL RAW MATERIALS PACKETS PURCHASED DURING LATE DECEMBER HAVE NOT BEEN PAID. Raw materials are payable on the 10th day of the month after the purchase.

f. Five hours of direct labor are required to assemble each device. The direct labor cost (including fringe benefits) is $22.00 per hour. Wages earned by employees during the first half of each month are paid on the third Friday of the current month. Wages earned in the second half of the month are paid on the first Friday of the next month. Assume that the workforce is stable each month (hence, wages and salaries are the same every day of the month).

g. Manufacturing overhead incurred averages 85% of direct labor cost. Manufacturing overhead percentage includes warehouse rent, insurance, utilities, etc. Manufacturing overhead is paid 40% in the current month with the remaining balance paid the following month.

h. Sales commissions are 14% of sales price. 100% of sales commissions are payable on the 15th day of the month after the sale.

i. Administrative salaries and fringe benefits are $60,000 per month. Administrative salaries are paid one-half on the third Friday of the current month and one-half is on the first Friday of the next month.

j. Rent on administrative office space is $10,000 per month. Rent for each month is due on the first day of each month.

k. On January 1, 20xx the Company will pay an $84,000 annual insurance liability premium covering January through December, 20xx. This insurance policy is a different policy than MOH insurance.

l. Other administrative expenses are estimated to be 7.5% of sales. Other administrative expenses are paid in the month after the expense occurs.

m. The federal and state income tax rate is estimated at 25%. Taxes accrue on each months income and will be paid quarterly on April 15, July 15, etc. Note: Your company is successful, and YOU WILL NEED TO PAY TAXES.

n. The company has a $750,000 line of credit secured to its inventory and accounts receivable through a private investor. Borrowing against this line must be in increments of $25,000 and happen on the 16th day of the month. Repayments must also occur in $25,000 increments on the 16th day of the month. Your borrowings and repayments should be adjusted to provide a minimum ending cash balance of $25,000 each month.

o. Interest for the line of credit is calculated at an annual rate of 6% assuming a 360 year. Interest expense is payable on the 1st day of the month after the borrowing occurred.

p. Beginning cash balance on January 1, 20xx is projected to be $24,000. This money was raised through issuing common stock and should be recorded accordingly.

Check Figures:

Production--March, Required Production, Units: 2266. If you get the wrong number, read D.

Raw Materials--March, Packets to Purchase, Units 2531. If you get the wrong number, read E between the first comma and the first period.

Income Statement--January, Sales: $1,397,250

Income Statement--January, Operating Income: $321,216

Income Statement--January, Net Income: $240,631

Cash Budget--January, Total Budget Disbursements: $631,095

Cash Budget--January, Ending Cash: $31,943

Balance Sheet--January, Total Assets: $1,339,999

Balance Sheet--February, Total Assets: $1,809,096

Balance Sheet--March, Total Assets: $2,194,972

ection 1: Note Payable lint: You can not calculate this number until you have complete the cash budget through Surplus/Shortage. Section 4: Interest Expense (to Income Statement) Hint: Look at this in 15 day increments instead of months. You are calculated interest for SIX periods based on how the loan documents works. If you are only off the interest for the entire project, it is not worth spending hours on for a couple of points. Section 5: Expected Cash Disbursements-Interest, 1st of Month (to Cash Budget) Hint: Remember there are SIX periods in the three months. Section 6: Interest Payable (to Balance Sheet) Hint: Remember there are SIX periods in the three months. Interest Payable, Beginning Bal Interest Payable, Ending Bal Sertinn Q. Incomo Tay Davahla Itn Ralanco Shoutl Section 1: Manufacturing Overhead Budget Total Labor Cost, in \$ (from Direct Labor) \% of Direct Labor to MOH Manufacturing Overhead, in \$ Section 2: Expected Cash Disbursements (to Cash Budget) \begin{tabular}{l|l|l|l|l|l} & Jan & Feb & Mar & Apr & Qtr Total \\ \hline Jan MOH, in \$ & & & & \\ \hline Feb MOH, in \$ & & & \\ \hline Mar MOH, in \$ & & & \\ \hline Total Cash Disbursement, in \$ & & & \\ \hline \end{tabular} Section 3: Accounts Payable (to Balance Sheet) Accounts Payable, Beginning Balance, in \$ \begin{tabular}{|c|c|c|c|c|} \hline Jan & Feb & Mar & Apr & Qtr Total \\ \hline \end{tabular} Accounts Payable, Ending Balance, in \$ ection 1: Note Payable lint: You can not calculate this number until you have complete the cash budget through Surplus/Shortage. Section 4: Interest Expense (to Income Statement) Hint: Look at this in 15 day increments instead of months. You are calculated interest for SIX periods based on how the loan documents works. If you are only off the interest for the entire project, it is not worth spending hours on for a couple of points. Section 5: Expected Cash Disbursements-Interest, 1st of Month (to Cash Budget) Hint: Remember there are SIX periods in the three months. Section 6: Interest Payable (to Balance Sheet) Hint: Remember there are SIX periods in the three months. Interest Payable, Beginning Bal Interest Payable, Ending Bal Sertinn Q. Incomo Tay Davahla Itn Ralanco Shoutl Section 1: Manufacturing Overhead Budget Total Labor Cost, in \$ (from Direct Labor) \% of Direct Labor to MOH Manufacturing Overhead, in \$ Section 2: Expected Cash Disbursements (to Cash Budget) \begin{tabular}{l|l|l|l|l|l} & Jan & Feb & Mar & Apr & Qtr Total \\ \hline Jan MOH, in \$ & & & & \\ \hline Feb MOH, in \$ & & & \\ \hline Mar MOH, in \$ & & & \\ \hline Total Cash Disbursement, in \$ & & & \\ \hline \end{tabular} Section 3: Accounts Payable (to Balance Sheet) Accounts Payable, Beginning Balance, in \$ \begin{tabular}{|c|c|c|c|c|} \hline Jan & Feb & Mar & Apr & Qtr Total \\ \hline \end{tabular} Accounts Payable, Ending Balance, in \$