Sales Cash Collection Budget-total for company (each quarter and total for 2024) Production Budget for each...
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
Answer rating: 100% (QA)
Here are the budgets you requested Sales Cash Collection Budget Quarter 1 3000... View the full answer
Related Book For
Managerial Accounting Creating Value in a Dynamic Business Environment
ISBN: 978-0078025662
10th edition
Authors: Ronald Hilton, David Platt
Posted Date:
Students also viewed these accounting questions
-
Jay Rexford, president of Photo Artistry Company, was just concluding a budget meeting with his senior staff. It was November of 20x4, and the group was discussing preparation of the firms master...
-
The Thompson Toy Company manufactures toy building block sets for children. Thompson is planning for 2017 by developing a master budget by quarters. Thompsons balance sheet for December 31, 2016,...
-
Jeffrey Vaughn, president of Frame-It Company, was just concluding a budget meeting with his senior staff. It was November of 20x0, and the group was discussing preparation of the firm's master...
-
A random variable follows the continuous uniform distribution between 60 and 95. a. Calculate the following probabilities for the distribution: 1. P(x > 63) 2. P(x > 70) 3. P(x > 88) 4. P(x = 75) b....
-
Your client, Ron Santo Leasing Company, is preparing a contract to lease a machine to Souvenirs Corporation for a period of 25 years. Santo has an investment cost of $365,755 in the machine, which...
-
Grupo Ignacia issued 10-year corporate bonds two years ago. The bonds pay an annualized coupon of 10.7 percent on a semiannual basis, and the current annualized YTM is 11.6 percent. The current price...
-
This is actually a paired data situation (since each person was measured before and after eating organic), so we create a new variable, the differences in pesticide concentration, by taking pesticide...
-
Heat transfer in laminar tube flow, One hundred pounds per hour of oil at 100F is flowing through a 1-in.i.d. Copper tube, 20ft long the inside surface of the tube is maintained at 215F by condensing...
-
How well did Allen interact with each member of the buying center? (Lawford Electric case) Lawford Electric Company (Revised) 580-124 Exhibit 1 (continued) Tension Reel-Hallden Shear System consists...
-
2. The Global Tea and Organic Juice companies have merged. The following information has been collected for the "Consolidation Project." Chapter 7 Managing Risk 245 Activity Description Predecessor a...
-
As a manager of a bond portfolio for a bank, you have a total sum of n loans in your portfolio. If each of these loans have credit events which are exponentially distributed with parameter A, or...
-
How are weekends and holidays handled when volatility is estimated and used?
-
In the Black-Scholes-Merton model, what happens to the standard deviation of the continuously compounded rate of return as the length of the time period over which it is measured increases?
-
Explain the two main ways that derivatives trade?
-
What are the properties of a Wiener process?
-
Explain the role of the Hurst exponent in fractional Brownian motion.
-
P1: For each of the following difference equations: Find the general solution. Assume in each case xo = 10. Find lim xn (if it exists). n- (a) Xn+1 = 0.9xn (b) Xn+1 = 2x + 2 (c) P2: 3xn+1-2x + 1 = 0...
-
Which property determines whether a control is available to the user during run time? a. Available b. Enabled c. Unavailable d. Disabled
-
Rapid City Technology, Inc. manufactures chemicals used in agricultural pest control. The controller has established the following activity cost pools and cost drivers. An order for 1,000 boxes of a...
-
Redstone Industrial Resources Company (RIRC) has several divisions. However, only two divisions transfer products to other divisions. The Mining Division refines toldine, which is then transferred to...
-
Happy Days Balloon Company incurred $167,000 of manufacturing overhead costs during the year just ended. However, only $145,000 of overhead was applied to production. At the conclusion of the year,...
-
Personalized medicine may be used a. to characterize types of tumors. b. to predict the outcome of certain types of cancers. c. to determine the proper dosage of drugs. d. in all of the above.
-
Tumor-suppressor genes promote cancer when a. they are overexpressed. b. they are expressed in the wrong cell type. c. their function is inactivated. d. they are expressed at the wrong stage of...
-
Which of the following is a type of genetic change that could produce an oncogene? a. Missense mutation b. Gene amplification c. Chromosomal translocation d. All of the above can produce an oncogene.
Study smarter with the SolutionInn App