Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed 

Exhibit 1 Summary of Ingredients Exhibit 2 List of S & A Expenses Per Quarter

Exhibit 3 Balance Sheet As of 12-31-2023 Assets Current Assets: Property, Plant, and Equipment Liabilities and Stock Holders 

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

Step by Step Solution

3.54 Rating (164 Votes )

There are 3 Steps involved in it

Step: 1

Here are the budgets you requested Sales Cash Collection Budget Quarter 1 3000... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting Creating Value in a Dynamic Business Environment

Authors: Ronald Hilton, David Platt

10th edition

78025664, 978-0078025662

More Books

Students also viewed these Accounting questions

Question

Find the first four terms of the indicated expansions. (2a x 1 ) 11

Answered: 1 week ago