Shrek & Fiona Company, manufacturer of a single product, is preparing their annual budget for 2021:...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Shrek & Fiona Company, manufacturer of a single product, is preparing their annual budget for 2021: Requirements: 1. Prepare a Sales Budget 2. Determine production volume 3. Estimate manufacturing costs and operating expenses a. Purchases (material) budget b. Personnel budget c. Overhead budget d. Selling and administrative budget 4. Determine cash flow and other financial effects a. Cash collection schedule b. Cash disbursement for purchases, factory overhead, and selling and administrative expenses c. Cash budget 5. Formulate Projected Financial Statements (As of December 31, 2021) a. Budgeted Cost of Goods Manufactured b. Budgeted Income Statement c. Budgeted Balance Sheet The following are the assumptions to be used: Current Assets Cash Accounts Receivable (N1) Less: Uncollectible accounts Inventories Raw Materials (12,000 pounds) Finished Goods (4,000 units) Total Current Assets Non-current Assets Property, plant, and equipment Less: Accumulated depreciation Shrek & Fiona Company Statement of Financial Position As of December 31, 2020 1,192,000 (22,400) 1,169,600 30,000 140,000 18,000 320,000 (64,000) 170,000 1,357,600 256,000 Current Liabilities Accounts Payable (N2) Taxes Payable Dividends Payable Total Current Liabilities Stockholder's Equity Common Stock (100,000 shares) Retained Earnings Total Stockholder's Equity 240,000 13,200 500,000 753,200 500,000 360,400 860,400 The following are the assumptions to be used: Current Assets Cash Accounts Receivable (N1) Less: Uncollectible accounts Inventories Raw Materials (12,000 pounds) Finished Goods (4,000 units) Total Current Assets Non-current Assets Property, plant, and equipment Less: Accumulated depreciation Total Assets N1 2020 3rd quarter sales P2,500,000 2020 4th quarter sales P3,100,000 N2 2020 3rd quarter purchases P300,000 2020 4th quarter purchases P330,000 Shrek & Fiona Company Statement of Financial Position As of December 31, 2020 1,192,000 (22,400) 1,169,600 18,000 30,000 140,000 170,000 1,357,600 320,000 (64,000) 256,000 P P 200,000 992,000 P 1,192,000 P 1,613,600 75,000 165,000 240,000 Current Liabilities Accounts Payable (N2) Taxes Payable Dividends Payable Total Current Liabilities Stockholder's Equity Common Stock (100,000 shares) Retained Earnings Total Stockholder's Equity Total Liabilities and SHE 240,000 13,200 500,000 753,200 500,000 360,400 860,400 1,613,600 1. Estimated unit sales for the first quarter of 2021 is 40,000 units and expected to increase 10% quarterly. Selling price fluctuates as follows: Quarter Unit price 1st 64 2nd 66 Assume that of each quarter's sales: 20% are cash sales while the remaining 80% are credit sales. Shrek & Fiona Company estimates that 60% of credit sales are collected in the quarter of sale with 2% discount, 30% in the quarter of following sale, 9% in the second quarter following sale and 1% are considered as uncollectible. 3rd 62 2. Finished product requires 3 pounds of direct materials at P2.50 per pound. Finished good ending inventory is equal to 10% of the next quarter sales while raw materials ending inventory is equal to 10% of the next quarter production needs of materials. First quarter of 2022 sales is expected to be at 50,000 units while raw materials ending is at 13,500 pounds. (Units are rounded to the nearest ones.) 3. Each quarter's purchase are paid 50% in that quarter with 5% purchase discount, 25% in the following quarter and the remainder in the second quarter following the purchase. 5. For Factory overhead budget, use the following cost formula: Indirect labor Indirect material Insurance Factory rent Utilities 4th 62 4. Each finished goods requires 5 direct labor hours with an hourly rate of P4.00 payable on the end of each month. Maintenance Depreciation PO.02 per direct labor worked (same payment scheme with direct labor) P2 per unit produced P48,000 annually, paid at the beginning of the year P6,500 per month P500 per quarter plus P0.50 per unit produced P300 per quarter plus P0.30 per unit produced 10% of the PPE cost, annually All overhead costs involve cash outlays are paid in the period which they are incurred, insurance cost. Worthy to note, the company assumes that all indirect materials are used and paid in the month it was purchased. 6. Selling and administrative expenses Advertising Commission Admin salaries Office rent P65,000 annually, paid at the beginning of the year 5% of total sales, paid quarterly P100,000 per quarter (same payment scheme with direct labor) P5,000 per month 7. Income tax is 30%, paid on the first quarter of the following year. 8. For cash budget, assume the following: a. The company desires to maintain P15,000 minimum cash balance b. Dividend is declared every end of the 4th quarter of the year P15 per issued and outstanding share and paid every 2nd quarter of the following year c. At the end of the 2nd quarter, the company plans to purchase P100,000 worth of equipment. d. Any excess cash at the end of the 1" quarter of the year is used to buy long term investments P10,000 increments. 3% interest rate is credited to the company's bank account at the quarter's end based on original cost of investment e. In case of deficit, the company borrow from the bank P10,000 increments, payable in one year, 10% interest rate is automatically debited to the company's bank account at the end of every quarter. Shrek & Fiona Company, manufacturer of a single product, is preparing their annual budget for 2021: Requirements: 1. Prepare a Sales Budget 2. Determine production volume 3. Estimate manufacturing costs and operating expenses a. Purchases (material) budget b. Personnel budget c. Overhead budget d. Selling and administrative budget 4. Determine cash flow and other financial effects a. Cash collection schedule b. Cash disbursement for purchases, factory overhead, and selling and administrative expenses c. Cash budget 5. Formulate Projected Financial Statements (As of December 31, 2021) a. Budgeted Cost of Goods Manufactured b. Budgeted Income Statement c. Budgeted Balance Sheet The following are the assumptions to be used: Current Assets Cash Accounts Receivable (N1) Less: Uncollectible accounts Inventories Raw Materials (12,000 pounds) Finished Goods (4,000 units) Total Current Assets Non-current Assets Property, plant, and equipment Less: Accumulated depreciation Shrek & Fiona Company Statement of Financial Position As of December 31, 2020 1,192,000 (22,400) 1,169,600 30,000 140,000 18,000 320,000 (64,000) 170,000 1,357,600 256,000 Current Liabilities Accounts Payable (N2) Taxes Payable Dividends Payable Total Current Liabilities Stockholder's Equity Common Stock (100,000 shares) Retained Earnings Total Stockholder's Equity 240,000 13,200 500,000 753,200 500,000 360,400 860,400 The following are the assumptions to be used: Current Assets Cash Accounts Receivable (N1) Less: Uncollectible accounts Inventories Raw Materials (12,000 pounds) Finished Goods (4,000 units) Total Current Assets Non-current Assets Property, plant, and equipment Less: Accumulated depreciation Total Assets N1 2020 3rd quarter sales P2,500,000 2020 4th quarter sales P3,100,000 N2 2020 3rd quarter purchases P300,000 2020 4th quarter purchases P330,000 Shrek & Fiona Company Statement of Financial Position As of December 31, 2020 1,192,000 (22,400) 1,169,600 18,000 30,000 140,000 170,000 1,357,600 320,000 (64,000) 256,000 P P 200,000 992,000 P 1,192,000 P 1,613,600 75,000 165,000 240,000 Current Liabilities Accounts Payable (N2) Taxes Payable Dividends Payable Total Current Liabilities Stockholder's Equity Common Stock (100,000 shares) Retained Earnings Total Stockholder's Equity Total Liabilities and SHE 240,000 13,200 500,000 753,200 500,000 360,400 860,400 1,613,600 1. Estimated unit sales for the first quarter of 2021 is 40,000 units and expected to increase 10% quarterly. Selling price fluctuates as follows: Quarter Unit price 1st 64 2nd 66 Assume that of each quarter's sales: 20% are cash sales while the remaining 80% are credit sales. Shrek & Fiona Company estimates that 60% of credit sales are collected in the quarter of sale with 2% discount, 30% in the quarter of following sale, 9% in the second quarter following sale and 1% are considered as uncollectible. 3rd 62 2. Finished product requires 3 pounds of direct materials at P2.50 per pound. Finished good ending inventory is equal to 10% of the next quarter sales while raw materials ending inventory is equal to 10% of the next quarter production needs of materials. First quarter of 2022 sales is expected to be at 50,000 units while raw materials ending is at 13,500 pounds. (Units are rounded to the nearest ones.) 3. Each quarter's purchase are paid 50% in that quarter with 5% purchase discount, 25% in the following quarter and the remainder in the second quarter following the purchase. 5. For Factory overhead budget, use the following cost formula: Indirect labor Indirect material Insurance Factory rent Utilities 4th 62 4. Each finished goods requires 5 direct labor hours with an hourly rate of P4.00 payable on the end of each month. Maintenance Depreciation PO.02 per direct labor worked (same payment scheme with direct labor) P2 per unit produced P48,000 annually, paid at the beginning of the year P6,500 per month P500 per quarter plus P0.50 per unit produced P300 per quarter plus P0.30 per unit produced 10% of the PPE cost, annually All overhead costs involve cash outlays are paid in the period which they are incurred, insurance cost. Worthy to note, the company assumes that all indirect materials are used and paid in the month it was purchased. 6. Selling and administrative expenses Advertising Commission Admin salaries Office rent P65,000 annually, paid at the beginning of the year 5% of total sales, paid quarterly P100,000 per quarter (same payment scheme with direct labor) P5,000 per month 7. Income tax is 30%, paid on the first quarter of the following year. 8. For cash budget, assume the following: a. The company desires to maintain P15,000 minimum cash balance b. Dividend is declared every end of the 4th quarter of the year P15 per issued and outstanding share and paid every 2nd quarter of the following year c. At the end of the 2nd quarter, the company plans to purchase P100,000 worth of equipment. d. Any excess cash at the end of the 1" quarter of the year is used to buy long term investments P10,000 increments. 3% interest rate is credited to the company's bank account at the quarter's end based on original cost of investment e. In case of deficit, the company borrow from the bank P10,000 increments, payable in one year, 10% interest rate is automatically debited to the company's bank account at the end of every quarter.
Expert Answer:
Answer rating: 100% (QA)
1Sales Budget Particulars Units Selling price Sales in amount 2Production Volume Particulars Sales A... View the full answer
Related Book For
Smith and Roberson Business Law
ISBN: 978-0538473637
15th Edition
Authors: Richard A. Mann, Barry S. Roberts
Posted Date:
Students also viewed these accounting questions
-
Goodwill at acquisition was calculated to be $60,000. The total assets in the consolidated statement of financial position as of December 31, 2019, were calculated to be $6,865,000. You are required...
-
Healey Corporation's statement of financial position as at December 31, 2017, showed the following amounts: Cash $100; Accounts Receivable $600; Land $1,000; Accounts Payable $300; Bonds Payable...
-
Healey Corporations statement of financial position as at December 31, 2020, showed the following amounts: Cash $100; Accounts Receivable $600; Land $1,000; Accounts Payable $300; Bonds Payable $500;...
-
An investor utilizes a bull call spread by purchasing a call option for a premium of $10. The call option comes with a strike price of $50 and expires in July 2020. At the same time, the investor...
-
Consider the following three specific functions for a functional relation between X and Y: i) Y = 50 + 2X ii) Y = 50 + 2X + 0.05X2 iii) Y = 50 + 2X 0.05X2 a. For the values of X of 0, 10, 20, 30,...
-
Coppins Sports Equipment Company made 44,000 basketballs in a given year. Its manufacturing costs were $294,800 variable and $9,100 fixed. Assume that no price changes will occur in the following...
-
Identify the assignment technique to be used. Discuss whether it will be experimental or quasi-experimental research. Develop a hypothetical research scenario that would necessitate the use of a...
-
Atmospheric air is in parallel flow (u = 15 m/s, T = 15C) over a flat heater surface that is to be maintained at a temperature of 140C. The heater surface area is 0.25 m2, and the airflow is known to...
-
dy Consider the differential equation =xy. dx a) What is the slope of the direction field at the point (1, 0.5)? b) What is the slope of the direction field at the point (-1.5, -0.5)? c) What is the...
-
Given the following adjusted account balances in random order, prepare the CLOSING entries on December 31, XX. Use the back of the paper if you need more room, or submit your answer on a separate...
-
Use the mutual fund quotes in table below, and assume that you can buy these funds at their quoted net asset values. Mutual Fund Quotes EXHIBIT 13.4 Open-end mutual funds are listed separately from...
-
When neither residents nor nonresidents are allowed to convert a currency to a foreign currency, the currency is considered Multiple choice question. nonconvertible. freely convertible. internally...
-
2. Determine the regular monthly deposit required to accumulate $20,000 in 5 years at an annual interest rate of 2.5% compounded monthlyly. (3 points) 3. Determine the Present Value of an annuity...
-
Suppose you were to start your own business as a solo CPA doing taxes. What pieces of the opportunity cost of running such a business resemble a fixed cost, and which pieces of the opportunity cost...
-
The table shows the demand schedule facing Nina, a monopolist selling baskets. What is the change in total revenue if she raises the price from $10 to $12? Price Number of Baskets Sold $ 20 3 18 5 16...
-
the Foreign Corrupt Practices Act (FCPA) of 1977 was the first major international law to address bribery. I'm sure you've read about the pros and cons of the bribery argument. What arguments are...
-
Kent is driving a car due west at a constant speed of 55 mph (miles per hour) and sees a speed limit sign that says 45 mph. Kent immediately starts slowing down the car at a constant rate. The speed...
-
(a) With not more than 300 words, examine why Malaysia missed its 2020 targets to divert 40% of waste from landfills and increase recycling rates to 22%. (10 marks) b) Why arent Malaysian recycling?...
-
Explain the parol evidence rule and identify the situations to which the rule does not apply.
-
Salem Supply Co. sells new and used gardening equipment. Ben Buyer purchased a slightly used riding lawn mower for $1,500. The price was considerably less than that of comparable used mowers. The...
-
We granted the application for direct appellate review of the defendant, Bayer Corporation (Bayer), to determine the enforceability of an arbitration provision appearing in the plaintiffs, Malden...
-
How does the Clinical Trial Application guide described in the example make the composing process for a new document easier? How is it informed by the evaluation process? What metaphors or analogies...
-
Why is the analyzing step of the process crucial to the success of a MedImmune proposal? In the discussion, draw students attention to the intersection of medical, legal, and social issues. Why is...
-
What are the advantages and disadvantages of the following other options: making an announcement on the companys internal website, sending a memo to each employee, sending an email to each employee,...
Study smarter with the SolutionInn App