Sales Cash Collection Budget-total for company (each quarter and total for 2024) Production Budget for each...

 

 

Transcribed Image Text:

Sales Cash Collection Budget-total for company (each quarter and total for 2024) Production Budget for each product (each quarter and total for 2024) Check figure: Total required production of muffins for the year is 161,290 units. Direct Materials Needed Budget for each product and respective materials needed, beginning and ending inventories, units and cost (each quarter and total for 2024) Check figure: 1st quarter total cost of direct materials to be purchased is $212,567. Purchases Budget for Materials-total for company (each quarter and total for 2024) Exhibit 1 Summary of Ingredients Muffins Materials: Flour Margarine Sugar Eggs Milk Mini Chips Baking Packet Cookies Materials: Flour Margarine Sugar Eggs Cocoa PB chips Baking Packet Bread Materials: Flour Sugar Milk Shortening Baking Packet Exhibit 2 List of S & A Expenses Per Quarter Advertising Cleaning Supplies Janitorial Services Office Staff Salaries Office Supplies Rent - Office Sales Salaries Top Management Salaries Utilities Office lbs./ Dozen 0.5 0.25 0.5 2 0.1 1 1 Units Needed 0.5 0.75 1 2 0.25 1 1 Units Needed 3 0.25 0.25 0.25 1 $ $ $ $ $ Price per lb. 0.15 $ 0.25 0.20 0.05 1.25 0.75 0.10 Cost per Unit 0.15 $ 0.25 0.20 0.05 1.50 0.75 0.10 Cost per Unit 0.15 0.20 1.25 0.50 0.10 40,000 1,000 6,000 25,000 3,000 $ 9,000 35,000 80,000 1,800 200,800 $ $ $ Total Cost 0.08 0.06 0.10 0.10 0.13 0.75 0.10 1.31 Total Cost 0.08 0.19 0.20 0.10 0.38 0.75 0.10 1.79 Total Cost 0.45 0.05 0.31 0.13 0.10 1.04 Exhibit 3 Current Assets: Cash Accounts Receivable Materials Inventory Finished Goods Inventory Total Current Assets Property, Plant, and Equipment Land. Total Assets Building Equipment Accumulated Depr -Equipment Total PPE ERB Balance Sheet As of 12-31-2023 Liabilities and Stock Holder's Equity Assets Liabilities Accounts Payable Mortgage Payable Total Liabilities Stockholder's Equity Common Stock (no par value; 150,000 shares outstanding) Exhibit A Sales Budget Retained Earnings Total Stockholder's Equity Total Liabilities and Stockholder's Equity Muffins Cookies Bread Exhibit B $ 40,000 812,025 21,098 13,831 $ 75,000 568,000 750,000 (90,000) $ 31,648 1,109,969 $ 150,000 898,337 $ 886,954 1,303,000 $2,189,954 $1,141,617 1,048,337 $2,189,954 Quarter Q1 Total Year Q2 Q3 $ 216,000.00 $ 226,800.00 $ 238,140.00 $285,768.00 $ 966,708.00 $ 273,000.00 $ 286,650.00 $300,982.50 $361,179.00 $1,221,811.50 $ 391,000.00 $ 410,550.00 $431,077.50 $517,293.00 $1,749,920.50 Q4 Quarter 2025 Q1 $ 300,056.40 $315,059.22 $ 379,237.95 $398,199.85 02 $ 543,157.65 $570,315.53 Sales Cash Collection Budget-total for company (each quarter and total for 2024) Production Budget for each product (each quarter and total for 2024) Check figure: Total required production of muffins for the year is 161,290 units. Direct Materials Needed Budget for each product and respective materials needed, beginning and ending inventories, units and cost (each quarter and total for 2024) Check figure: 1st quarter total cost of direct materials to be purchased is $212,567. Purchases Budget for Materials-total for company (each quarter and total for 2024) Exhibit 1 Summary of Ingredients Muffins Materials: Flour Margarine Sugar Eggs Milk Mini Chips Baking Packet Cookies Materials: Flour Margarine Sugar Eggs Cocoa PB chips Baking Packet Bread Materials: Flour Sugar Milk Shortening Baking Packet Exhibit 2 List of S & A Expenses Per Quarter Advertising Cleaning Supplies Janitorial Services Office Staff Salaries Office Supplies Rent - Office Sales Salaries Top Management Salaries Utilities Office lbs./ Dozen 0.5 0.25 0.5 2 0.1 1 1 Units Needed 0.5 0.75 1 2 0.25 1 1 Units Needed 3 0.25 0.25 0.25 1 $ $ $ $ $ Price per lb. 0.15 $ 0.25 0.20 0.05 1.25 0.75 0.10 Cost per Unit 0.15 $ 0.25 0.20 0.05 1.50 0.75 0.10 Cost per Unit 0.15 0.20 1.25 0.50 0.10 40,000 1,000 6,000 25,000 3,000 $ 9,000 35,000 80,000 1,800 200,800 $ $ $ Total Cost 0.08 0.06 0.10 0.10 0.13 0.75 0.10 1.31 Total Cost 0.08 0.19 0.20 0.10 0.38 0.75 0.10 1.79 Total Cost 0.45 0.05 0.31 0.13 0.10 1.04 Exhibit 3 Current Assets: Cash Accounts Receivable Materials Inventory Finished Goods Inventory Total Current Assets Property, Plant, and Equipment Land. Total Assets Building Equipment Accumulated Depr -Equipment Total PPE ERB Balance Sheet As of 12-31-2023 Liabilities and Stock Holder's Equity Assets Liabilities Accounts Payable Mortgage Payable Total Liabilities Stockholder's Equity Common Stock (no par value; 150,000 shares outstanding) Exhibit A Sales Budget Retained Earnings Total Stockholder's Equity Total Liabilities and Stockholder's Equity Muffins Cookies Bread Exhibit B $ 40,000 812,025 21,098 13,831 $ 75,000 568,000 750,000 (90,000) $ 31,648 1,109,969 $ 150,000 898,337 $ 886,954 1,303,000 $2,189,954 $1,141,617 1,048,337 $2,189,954 Quarter Q1 Total Year Q2 Q3 $ 216,000.00 $ 226,800.00 $ 238,140.00 $285,768.00 $ 966,708.00 $ 273,000.00 $ 286,650.00 $300,982.50 $361,179.00 $1,221,811.50 $ 391,000.00 $ 410,550.00 $431,077.50 $517,293.00 $1,749,920.50 Q4 Quarter 2025 Q1 $ 300,056.40 $315,059.22 $ 379,237.95 $398,199.85 02 $ 543,157.65 $570,315.53

Answer rating: 100% (QA)

Here are the budgets you requested Sales Cash Collection Budget Quarter 1 3000... View the full answer