Betty's Design Projected Income Statement As of December 31, 2022 Sales 25,000 Lamps @ $45.00 Cost of Goods Sold @ $28.93 Gross Profit Selling Expenses: Fixed Variable (Commission per unit) @$3.1578,750.00101,750.00 Administrative Expenses: Fixed Total Selling and Administrative Expenses Net Profit 256,500.00145,250.00 Betty's Design Projected Balance Sheet As of December 31, 2022 Current Assets Cash Accounts Receivable $34,710.0067,500.00 Inventory Raw Material \begin{tabular}{lcr} Figurines & 500@$9.20 & 4,600.00 \\ Electrical Sets & 500@$1.25 & 625.00 \\ Work in Process & 0 & \\ Finished Goods & 3000@$28.93 & $6,790.00 \\ \hline Total Current Assets & & 194,225.00 \end{tabular} Fixed Assets Equipment Accumulated Depreciation Total Fixed Assets Total Assets $207,425.0013,200.00 Current Liabilities Accounts Payable Total Liabilities $$54,000.0054,000.00 Stockholders' Equity Common Stock Retained Earnings $12,000.00141,425.00 Total Stockholders' Equity Total Liabilities and Stockholders' Equity $207,425.00153,425.00 PART 5 BUDGETS Division B has decided to develop its budget based upon projected sales of 27,000 lamps at $48.00 per lamp. The company has requested that you prepare a master budget for the year. This budget is to be used for planning and control of operations and should be composed of: 1. Production Budget 2. Materials Budget 3. Direct Labor Budget 4. Factory Overhead Budget 5. Selling and Administrative Budget 6. Cost of Goods Sold Budget 7. Budgeted Income statement 8. Cash Budget Notes For Budgeting: The company wants to maintain the same number of units in the beginning and ending inventories of work-in-process, and electrical parts while increasing the figurines inventories to 525 pieces and decreasing the finished goods by 20%. Complete the following budgets 1. Production Budget Ref\# \#\#\# 2. Materials Budget \begin{tabular}{|l|l|l|l|l|} \hline \multicolumn{2}{|l|}{ Electrical Parts } & \multicolumn{2}{l|}{} & Ref \# \\ \hline Needed For Production & From 7.01 & & units & \\ \hline Desired Ending Inventory & & & units & \\ \hline Total Needed & & & units & 8.06 \\ \hline \multicolumn{1}{|c|}{ Less: Beginning Inventory } & & & units & \\ \hline Total Purchases & & & units & \\ \hline Cost per piece & From 4.02 & $ & & \\ \hline Cost of Purchases (Round to two places, \$\#\#.\#\#) & & $ & & 8.07 \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|} \hline \multicolumn{2}{|l|}{ Lamp Shades } & \multicolumn{2}{l|}{} & Ref \# \\ \hline Needed For Production & From 7.01 & & units & \\ \hline Desired Ending Inventory & & & units & \\ \hline Total Needed & & & units & \\ \hline \multicolumn{1}{|c|}{ Less: Beginning Inventory } & & & units & \\ \hline Total Purchases & & & units & \\ \hline Cost per piece & From 4.03 & $ & & \\ \hline Cost of Purchases (Round to two places, \$\#\#.\#\#) & & $ & & 8.08 \\ \hline \end{tabular} 3. Direct Labor Budget \begin{tabular}{|l|l|l|l|l|} \hline Labor Cost per Lamp & From 4.04 & $ & & \\ \hline Production & & & units & \\ \hline Total Labor Cost (Round to two places, \$\#\#.\#\# & & $ & & 8.09 \\ \hline \end{tabular} 4. Factory Overhead Budget \begin{tabular}{|l|l|l|l|l|} \hline Variable Factory Overhead: & \multicolumn{2}{l|}{} & Ref \# \\ \hline Variable Factory Overhead Cost per Unit & From 4.05 & $ & \\ \hline Number of Units to be Produced & From 7.01 & & units & \\ \hline Total Variable Factory Overhead & & $ & & 8.10 \\ \hline (Round to two places, \$\#\#.\#\#) & & & & \\ \hline Fixed Factory Overhead & & & & 8.11 \\ \hline Total Factory Overhead & & $ & & \\ \hline (Round to two places, \$\#\#.\#\#) & \multicolumn{2}{|l}{} \\ \hline \end{tabular} Overhead Allocation rate based on: A. Nu B. Di C. Dir Selling and Administrative Budget Cost of Goods Sold Budget Assume FIFO (First-In, First-Out) and overhead is applied based on the number of units to be produced. (Round dollars to two places $X.XX ) Ending Inventory of Figurines $ Figurines Used in Production Electrical Parts: Beginning Inventory From B/5 Purchased Available for Use Ending Inventory of Electrical Parts (Part 5(b) * 4.02) Electrical Parts Used in Production Lamp Shades: Lamp Shades Used in Production Total Materials Labor Overhead Cost of Goods Available Less: Ending Inventory, Finished Goods Cost of Goods Sold