Using the following information, you are to prepare a comprehensive budget for Friends, Again. The Company, Friends, Again, assembles a specialized device used to help friends enjoy back yard BBQs. Arrangements have been made for the component parts (bundled in packets; one packet is used to assemble one unit) to be produced in Morocco, shipped to Boise, then assembled and sold by Friends, Again You have developed the prototypes, established a market, and now you are putting together a budget for the first three months of operations. The Company will start manufacturing and distribution on January 1,20xx. No expenses occur nor does cash leave the company before January 1, 20xx. Assume all 12 months have 30 days to make the calculations easier. This is commonly done in the business world. Use the following assumptions in making your budget calculations: A. Projected sales in units are 1558 in January and increase by 265 units each month through the remainder of the year. 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 34% in the month of sale, 34% 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. B. The company wants to have at least 30% of the next month's projected sales in ending finished goods inventory on hand. (Since the company is just starting. beginning January finished good will be zero.) C. 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 $139.00. The company will have 2275 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 10 th day of the month after the purchase. D. Five hours of direct labor are required to assemble each device. The direct labor cost (including fringe benefits) is $24.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. E. 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. F. Create a Cost of Goods Schedule (LO 2.3). All numbers should be in $ and linked from tab B, C, D, E. G1. Sales commissions are 14% of sales price. 100% of sales commissions are payable on the 15 th day of the month after the sale. G2. Bad debt expense was calculated on tabA. G3. Other administrative expenses are estimated to be 7.5% of sales. Other administrative expenses are paid in the month after the expense occurs. H1. Rent on administrative office space is $10,000 per month. Rent for each month is due on the first day of each month. H2. 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. H3. 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. 1. Using the provided template, create a Proforma Income Statement based on calculations from tab A through H. J1. Create a Proforma Cash Budget based on calculations from tab A through H. Beginning cash balance on January 1,20xx is projected to be $25,000. This money was raised through issuing common stock. J2. The company has a $750,000 line of credit secured to its inventory and accounts receivable through a private investor. Borrowing and repayments against this line must be in increments of $25,000 and will happen on the 1 st day of each month. You NEED TO pay back as much as you can to avoid interest. To simplify this project, NO interest will be calculated. J3. The minimum cash balance the company would like to keep on hand is $10,000. Production--March, Required Production, Units: 2168. If you get the wrong number, read B. Raw Materials--March, Packets to Purchase, Units 2433. If you get the wrong number, read C between the first comma and the first period. COGS--January, Raw Materials Used: $292,581 COGS--February, Cost of Goods Manufactured: $686,803 COGS--March, Cost of Goods Sold: $753,768 Income Statement--January, Sales: $1,406,095 Income Statement--January, Net Income: $295,615 Cash Budget--January, Total Budget Disbursements: $652,399 Cash Budget--January, Ending Cash: \$15,673 Tab C. Direct Materials (DM) D. Direct Labor (DL) Section 1: Direct Labor Budget (to COGS) \begin{tabular}{|l|c|c|c|c|c|} \hline \begin{tabular}{l} Required Production, Units (From Production) \\ Labor Hours Per Unit \end{tabular} & Jan & Feb & Mar & Apr & Qtr Total \\ \hline \begin{tabular}{l} Total Labor Hours \\ Labor Cost Per Hour \end{tabular} & & & \\ \hline Total Labor Cost, in \$ & & & & \\ \hline & & & & \\ \hline Section 2: Expected Cash Disbursements (to Cash Budget) & & & & \\ \hline \begin{tabular}{l} Jan Direct Labor, in \$ \\ Feb Direct Labor, in \$ \end{tabular} & Feb & Mar & Apr & Qtr Total \\ \hline \begin{tabular}{l} Mar Direct Labor, in \$ \\ Total Cash Disbursements, in \$ \end{tabular} & & & & \\ \hline \end{tabular} Tab E. Overhead (OH) \begin{tabular}{|c|c|c|c|c|c|} \hline \multicolumn{6}{|c|}{ Section 1: Manufacturing Overhead Budget (to COGS) } \\ \hline & Jan & Feb & Mar & Apr & Qtr Total \\ \hline \multicolumn{6}{|c|}{ Total Labor Cost, in $ (from Direct Labor) } \\ \hline \multicolumn{6}{|l|}{\begin{tabular}{l} \% of Direct Labor to MOH \\ Manufacturing Overhead, in S \end{tabular}} \\ \hline \multicolumn{6}{|l|}{ Manufacturing Overhead, in \$ } \\ \hline \multicolumn{6}{|c|}{ Section 2: Expected Cash Disbursements (to Cash Budget) } \\ \hline & Jan & Feb & Mar & Apr & Qtr Total \\ \hline \multicolumn{6}{|l|}{\begin{tabular}{l} Jan MOH, in $ \\ FebMOH, in $ \end{tabular}} \\ \hline \multicolumn{6}{|l|}{\begin{tabular}{l} Feb MOH, in $ \\ Mar MOH, in S \end{tabular}} \\ \hline \multicolumn{6}{|l|}{\begin{tabular}{l} Mar MOH, in S \\ Total Cash Disbursement, in \$ \end{tabular}} \\ \hline Total Cash Disbursement, in \$ & & & & & \\ \hline \end{tabular} Name: Section 1: Cost of Goods Sold (to Income Statement) Note: All numbers for this tab have been calculated in previous tabs. G. SG\&A Exp-Variable Section 3: Expected Cash Disbunements-Bad Debt Expense (to Section 5) Remembers bod Debt has nothing to Feb Mar ApR Qtr Total do with cash. Section 4: Expected Cash Disbursements-Other Admin Expenso Ita Seetinn 5t Section 5: Total Cash Disbursements for ScRA A and fixed tabs calculations DO NOT intermix. Cantinn a. Fvnotad Cash Dishursements-Insurance (to Section 5) Tab J. Proforma Cash Budget