Background Information Betty's Design is a subchapter S corporation that manufactures children's lampsightlights for use in bedrooms. These lamps are sold nationwide through a group of independent sales representatives who have an exclusive sales region. The business is in its tenth year and has asked you to assist in planning for next year's operations. The lamps are ceramic figurines of animals, boats, boys and girls playing and singing, all in delightful colors. The owner of the business, Betty, creates a drawing for the figurine and faxes it to a plant in China where a mold is created and a sample produced and hand painted. If the mold meets the expectations of Betty an order of 500 pieces is placed. There are presently 10 different figurines that come in six different colors; 60 models. The lamp shades and the electrical parts are supplied from domestic manufacturers. There are presently 10 workers in the plant. They are responsible for receiving the raw material, manufacturing the product, packing and shipping. In addition to Betty there are two office workers who are responsible for all administrative duties. Betty had her accountant prepare the Projected Income Statement and Balance Sheet presented in the two proceeding tabs. Betty heard about your skills in managerial accounting and would like your assistance in the following areas: Part 1: Fixed and Variable Cost Determinations Part 2: Cost Volume Profit Relationships Part 3: Job Order Costing Part 4: (Independent of Parts 1-3) COGM and COGS Part 5: Budgets Part 6: Process Costing - Weighted Average Part 7: Standard Costing - Variance Analysis 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 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 Background Information Betty's Design is a subchapter S corporation that manufactures children's lampsightlights for use in bedrooms. These lamps are sold nationwide through a group of independent sales representatives who have an exclusive sales region. The business is in its tenth year and has asked you to assist in planning for next year's operations. The lamps are ceramic figurines of animals, boats, boys and girls playing and singing, all in delightful colors. The owner of the business, Betty, creates a drawing for the figurine and faxes it to a plant in China where a mold is created and a sample produced and hand painted. If the mold meets the expectations of Betty an order of 500 pieces is placed. There are presently 10 different figurines that come in six different colors; 60 models. The lamp shades and the electrical parts are supplied from domestic manufacturers. There are presently 10 workers in the plant. They are responsible for receiving the raw material, manufacturing the product, packing and shipping. In addition to Betty there are two office workers who are responsible for all administrative duties. Betty had her accountant prepare the Projected Income Statement and Balance Sheet presented in the two proceeding tabs. Betty heard about your skills in managerial accounting and would like your assistance in the following areas: Part 1: Fixed and Variable Cost Determinations Part 2: Cost Volume Profit Relationships Part 3: Job Order Costing Part 4: (Independent of Parts 1-3) COGM and COGS Part 5: Budgets Part 6: Process Costing - Weighted Average Part 7: Standard Costing - Variance Analysis