. Heron, Inc. is a company that re-sells one product, a lawn chair. A contractor makes...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
. Heron, Inc. is a company that re-sells one product, a lawn chair. A contractor makes the product exclusively for Heron, so Heron has no manufacturing costs. Henron sells each chair for $10 per unit, but plans to raise the sales price to $11.00 per unit beginning May 1, 2018 2. The estimated sales (in units) are as follows: Dec 17 Jan 18 13,000 9,000 Nov 17 12,000 Feb 18 10,000 Mar 18 13,000 Apr 18 15,000 May 18 Jun 18 18,000 18,000 Jul 18 17,000 . They expect that 60% of any month's sales are for cash, and the remaining 40% are on credit. Of the credit sales, they expect to collect 20% in the month of the sale, 70% in the following month, and 10% in the month after that. The firm's policy regarding inventory is to stock (i.e. have in ending inventory) 30% of the estimated sales for the next month. 5. Each lawn chair costs Henron $6. They plan to pay for 30% of the inventory purchases in the month of purchase, and pay the remaining 70% the following month (i.e. all of the previous month's Accounts Payable are paid off by the end of any month.) Monthly operating expenses consist of the following (any cash expenses are paid as incurred): Salaries and Wages Expense $17,000 Sales Commissions 7% of sales revenue Rent Expense $6,000 $2,000 $5,000 $2,500 Supplies Expense Other Overhead Expense Depreciation Expense Henron must maintain a minimum cash balance of $30,000. Borrowing can make up shortfalls. For simplicity, assume that the bank will only lend (and accept repayments) in $1,000 increments. Ignore interest on the loan in your calculations, but only borrow what you need, and pay off any loans as soon as possible. Cash on hand as of December 31, 2017 is expected to be $15,000. In addition, there will be no notes payable (loan balance) as of this date. See below the other Balance Sheet accounts with their balances as of the beginning of the year: $1,050,000 $ 520,000 $ 200,000 $360,040 Buildings and Equipment Accumulated Deprecation Common Stock Retained Earnings Note: You must add current year depreciation expense to accumulated depreciation. .Henron maintains office supplies of $2,000 at the end of each month. Accounts receivable consists of the credit sales that have not been received. Accounts payable consists of inventory purchases that have not yet been paid. 3 4 5 6 A 7 8 Budged unit sales 9 Selling price per unit 10 Total Sales Revenue 11 12 Cash Sales % 13 Credit Sales % 14 15 Cash Sales 16 Credit Sales 17 Total Sales Revenue 34 35 Desired ending inventory% 36 37 38 39 40 41 42 Budged unit sales 43 Add desired ending inventory 44 Total needs 18 19 20 Current month A/R Collections 21 month prior A/R Collections 22 months prior A/R Collections 23 24 25 26 27 28 29 Current month cash sales 30 Collections of credit sales made this month 31 Collections of credit sales made last month 32 Collections of credit sales made 2 months ago 33 Total cash collections 45 Less Beginning Inventory 46 Required Purchases 47 48 Cost per unit 49 Total purchases cost 50 51 % Paid in Month of Purchase 52 % Paid in Month after Purchase 53 B Nov 2017 60% 40% 20% 70% 10% 30% Nov 2017 30% 70% Dec 2017 $ E Henron, Inc. Sales Budget For the 6 mos ending June 30, 2018 Dec 2017 of next month unit sales Jan 2018 Henron, Inc. Cash Collections For the 6 mos ending June 30, 2018 Jan 2018 Feb 2018 6.00 $ Feb 2018 6.00 $ Henron, Inc. Purchase Budget For the 6 mos ending June 30, 2018 Jan 2018 Feb 2018 Mar 2018 6.00 $ F Mar 2018 Mar 2018 6.00 $ Apr 2018 Apr 2018 Apr 2018 6.00 $ H May 2018 May 2018 May 2018 6.00 $ Jun 2018 Jun 2018 Jun 2018 6.00 6 mos total 6 mos total 6 mos total 54 55 56 57 58 59 Payment for current month purchases 60 Payment for prior month purchases 61 Cash disbursements for merch purchases 85 28348688RFNRNRRERRS583028 64 Fixed Operating expenses: Salaries and Wages Expense Rent Expense 67 Supplies Expense Other Overhead Expenses Depreciation Expense 66 69 70 71 72 73 74 75 76 77 Sales Commissions 78 Rent Expense 87 79 Supplies Expense 80 Other Overhead Expenses 81 Depreciation Expense Total operating expenses 83 Subtract non-cash expenses: Depreciation Cash disbursements for operating expenses 89 90 91 92 Cash balance, beginning 93 Add collections from customers 94 96 95 Less disbursements: 97 Salaries and Wages Expense 98 99 100 101 102 104 Total cash available B Cash disbursements for merch purchases Cash disbursements for operating expenses Total cash disbursements Cash balance before financing Financing: Borrowing (repayments) - note payable Cash balance, ending 17,000 6,000 2,000 5,000 2,500 o E Heron, Inc. Schedule of Budgeted Cash Disbursements for Merchandise Purchases For the 6 mos ending June 30, 2018 Jan 2018 Variable Operating Expenses: Sales Commissions, % of sales revenue Feb 2018 Heron, Inc. Operating Expense Budget For the 6 mos ending June 30, 2018 Jan 2018 Feb 2018 $ Jan 2018 15,000 Heron, Inc. Cash Budget For the 6 mos ending June 30, 2018 FL Mar 2018 Feb 2018 Mar 2018 C Mar 2018 Apr 2018 7% Apr 2018 Apr 2018 H May 2018 May 2018 May 2018 Jun 2018 Jun 2018 6 mos total 6 mos total Jun 2018 6 mos total A 105 106 107 108 109 110 Sales, net 111 Cost of Goods Sold 112 Gross margin 113 Total operating expenses 114 Net Income 115 116 117 118 119 120 Retained Earnings, beginning 121 Add Net Income 122 Retained Earnings, ending 123 Heron, Inc. Budgeted Statement of Retained Earnings For the 6 mos ending June 30, 2018 124 125 126 127 128 Assets: 129 Current Assets: 130 Cash 131 Accounts Receivable 132 Office Supplies 133 134 135 Plant and Equipment: 136 Buildings and Equipment 137 Accumulated Depreciation 138 Total Plant and Equipment 139 Total assets Heron, Inc. Budgeted Balance Sheet As of June 30, 2018 Merchandise Inventory Total Current Assets 140 141 Liabilities: 142 Accounts Payable 143 B 144 Equity: 145 Common Stock 146 Retained Earnings 147 Total Equity 148 Total liabilities and equity 2,000 1,050,000 (520,000) 200,000 C 370,660 E Heron, Inc. Budgeted Income Statement For the 6 mos ending June 30, 2018 D Jan 2018 Feb 2018 F Mar 2018 G Apr 2018 H May 2018 1 Jun 2018 J 6 mos total . Heron, Inc. is a company that re-sells one product, a lawn chair. A contractor makes the product exclusively for Heron, so Heron has no manufacturing costs. Henron sells each chair for $10 per unit, but plans to raise the sales price to $11.00 per unit beginning May 1, 2018 2. The estimated sales (in units) are as follows: Dec 17 Jan 18 13,000 9,000 Nov 17 12,000 Feb 18 10,000 Mar 18 13,000 Apr 18 15,000 May 18 Jun 18 18,000 18,000 Jul 18 17,000 . They expect that 60% of any month's sales are for cash, and the remaining 40% are on credit. Of the credit sales, they expect to collect 20% in the month of the sale, 70% in the following month, and 10% in the month after that. The firm's policy regarding inventory is to stock (i.e. have in ending inventory) 30% of the estimated sales for the next month. 5. Each lawn chair costs Henron $6. They plan to pay for 30% of the inventory purchases in the month of purchase, and pay the remaining 70% the following month (i.e. all of the previous month's Accounts Payable are paid off by the end of any month.) Monthly operating expenses consist of the following (any cash expenses are paid as incurred): Salaries and Wages Expense $17,000 Sales Commissions 7% of sales revenue Rent Expense $6,000 $2,000 $5,000 $2,500 Supplies Expense Other Overhead Expense Depreciation Expense Henron must maintain a minimum cash balance of $30,000. Borrowing can make up shortfalls. For simplicity, assume that the bank will only lend (and accept repayments) in $1,000 increments. Ignore interest on the loan in your calculations, but only borrow what you need, and pay off any loans as soon as possible. Cash on hand as of December 31, 2017 is expected to be $15,000. In addition, there will be no notes payable (loan balance) as of this date. See below the other Balance Sheet accounts with their balances as of the beginning of the year: $1,050,000 $ 520,000 $ 200,000 $360,040 Buildings and Equipment Accumulated Deprecation Common Stock Retained Earnings Note: You must add current year depreciation expense to accumulated depreciation. .Henron maintains office supplies of $2,000 at the end of each month. Accounts receivable consists of the credit sales that have not been received. Accounts payable consists of inventory purchases that have not yet been paid. 3 4 5 6 A 7 8 Budged unit sales 9 Selling price per unit 10 Total Sales Revenue 11 12 Cash Sales % 13 Credit Sales % 14 15 Cash Sales 16 Credit Sales 17 Total Sales Revenue 34 35 Desired ending inventory% 36 37 38 39 40 41 42 Budged unit sales 43 Add desired ending inventory 44 Total needs 18 19 20 Current month A/R Collections 21 month prior A/R Collections 22 months prior A/R Collections 23 24 25 26 27 28 29 Current month cash sales 30 Collections of credit sales made this month 31 Collections of credit sales made last month 32 Collections of credit sales made 2 months ago 33 Total cash collections 45 Less Beginning Inventory 46 Required Purchases 47 48 Cost per unit 49 Total purchases cost 50 51 % Paid in Month of Purchase 52 % Paid in Month after Purchase 53 B Nov 2017 60% 40% 20% 70% 10% 30% Nov 2017 30% 70% Dec 2017 $ E Henron, Inc. Sales Budget For the 6 mos ending June 30, 2018 Dec 2017 of next month unit sales Jan 2018 Henron, Inc. Cash Collections For the 6 mos ending June 30, 2018 Jan 2018 Feb 2018 6.00 $ Feb 2018 6.00 $ Henron, Inc. Purchase Budget For the 6 mos ending June 30, 2018 Jan 2018 Feb 2018 Mar 2018 6.00 $ F Mar 2018 Mar 2018 6.00 $ Apr 2018 Apr 2018 Apr 2018 6.00 $ H May 2018 May 2018 May 2018 6.00 $ Jun 2018 Jun 2018 Jun 2018 6.00 6 mos total 6 mos total 6 mos total 54 55 56 57 58 59 Payment for current month purchases 60 Payment for prior month purchases 61 Cash disbursements for merch purchases 85 28348688RFNRNRRERRS583028 64 Fixed Operating expenses: Salaries and Wages Expense Rent Expense 67 Supplies Expense Other Overhead Expenses Depreciation Expense 66 69 70 71 72 73 74 75 76 77 Sales Commissions 78 Rent Expense 87 79 Supplies Expense 80 Other Overhead Expenses 81 Depreciation Expense Total operating expenses 83 Subtract non-cash expenses: Depreciation Cash disbursements for operating expenses 89 90 91 92 Cash balance, beginning 93 Add collections from customers 94 96 95 Less disbursements: 97 Salaries and Wages Expense 98 99 100 101 102 104 Total cash available B Cash disbursements for merch purchases Cash disbursements for operating expenses Total cash disbursements Cash balance before financing Financing: Borrowing (repayments) - note payable Cash balance, ending 17,000 6,000 2,000 5,000 2,500 o E Heron, Inc. Schedule of Budgeted Cash Disbursements for Merchandise Purchases For the 6 mos ending June 30, 2018 Jan 2018 Variable Operating Expenses: Sales Commissions, % of sales revenue Feb 2018 Heron, Inc. Operating Expense Budget For the 6 mos ending June 30, 2018 Jan 2018 Feb 2018 $ Jan 2018 15,000 Heron, Inc. Cash Budget For the 6 mos ending June 30, 2018 FL Mar 2018 Feb 2018 Mar 2018 C Mar 2018 Apr 2018 7% Apr 2018 Apr 2018 H May 2018 May 2018 May 2018 Jun 2018 Jun 2018 6 mos total 6 mos total Jun 2018 6 mos total A 105 106 107 108 109 110 Sales, net 111 Cost of Goods Sold 112 Gross margin 113 Total operating expenses 114 Net Income 115 116 117 118 119 120 Retained Earnings, beginning 121 Add Net Income 122 Retained Earnings, ending 123 Heron, Inc. Budgeted Statement of Retained Earnings For the 6 mos ending June 30, 2018 124 125 126 127 128 Assets: 129 Current Assets: 130 Cash 131 Accounts Receivable 132 Office Supplies 133 134 135 Plant and Equipment: 136 Buildings and Equipment 137 Accumulated Depreciation 138 Total Plant and Equipment 139 Total assets Heron, Inc. Budgeted Balance Sheet As of June 30, 2018 Merchandise Inventory Total Current Assets 140 141 Liabilities: 142 Accounts Payable 143 B 144 Equity: 145 Common Stock 146 Retained Earnings 147 Total Equity 148 Total liabilities and equity 2,000 1,050,000 (520,000) 200,000 C 370,660 E Heron, Inc. Budgeted Income Statement For the 6 mos ending June 30, 2018 D Jan 2018 Feb 2018 F Mar 2018 G Apr 2018 H May 2018 1 Jun 2018 J 6 mos total
Expert Answer:
Answer rating: 100% (QA)
Sales Forecast and Budget Req 1 Budgeted unit sales Selling price per unit Total sales Cash sales Cr... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Is a company that prepares financial statements in U.S. dollars required to disclose supplementary information on the effects of changing prices?
-
Comfortable Hands is a company that features a product line of winter gloves for the entire family-men, women, and children. They are trying to decide what mix of these three types of gloves to...
-
The company Smart Inc. is a company that produces Dog Shampoo in Toronto area. The results of the company, which has been mediocre for the past couple of years, have been presented in the annual...
-
Find the magnitude and direction of the electric field strength at the point P due to the point charges at A and B as shown in the Figure 1. (k = 9 x 10 Nm/C) +2 C 10 cm A 10 cm Figure 1 B -8 C (5...
-
Discuss the tax basis calculation adjustment. Why is the gain or loss on the sale of depreciable assets different for AMT purposes than for regular tax purposes?
-
Explain dignity in the context of a. Dignity of country b. Dignity of person c. Dignity in sports d. Dignity in profession e. Dignity in animals
-
A distillation tower with sieve trays is to separate benzene from mono-chlorobenzene. Conditions at a plate near the bottom of the column are: Vapor Phase Mass flow rate \(=24,850 \mathrm{lb} /...
-
Suppose Poseidon Publishing Company acquired all the common shares of Neptune Book Company for $80 million cash at the start of the year. Immediately before the business combination, each company had...
-
How can Forensic psychology be used in a criminal investigation? What is the history of Forensic psychology and how it has evolved? Why is Forensic Psychology an important resource to law enforcement...
-
A mass-transfer process is used to remove ammonia (NH 3 , solute A) from a mixture of NH 3 and air, using water as the absorption solvent. At the present conditions of operation, the partial pressure...
-
An Underwriter buys securities from the issuer and sells them privately or to the public. To diversify the risk of buying the securities and not being able to sell them, the underwriting firm can...
-
On January 2, 2018, Upton, Inc., signed a ten-year lease for office space. Upton classified the lease as a finance lease. Upton has the option to renew the lease for an additional five-year period on...
-
b) In addition to its data centre in Texas, BitTech currently has 1,000 servers located in Singapore. These are deployed for cloud services. With the advent of AI technologies such as Google Bard,...
-
1. Reduce your nervousness when speaking in a discussion or meeting 2. Understand, respect, and adapt to diverse group members 3. Communicate openly and honestly 4. Assume critical task roles...
-
For each of the following steps during mise-en-place, use one example to explain the precautionary measures you would take to ensure requirements for special dietary food dishes are not compromised,...
-
A client tells you they can't convert an estimate to a purchase order. Which 2 of these might be the reason? They're not set up as Company admin They haven't added QuickBooks Payments to their...
-
Suppose a bond has a $1,000 face value and a coupon interest rate of 6% per year. This bond promises to pay $60 (6% $1,000) each year, plus $1,000 when the bond matures in 2 years. If the market...
-
Consider the reaction of acetic acid in water CH 3 CO 2 H(aq) + H 2 O(l) CH3CO 22 (aq) + H 3 O + (aq) where Ka 5 1.8 3 1025. a. Which two bases are competing for the proton? b. Which is the stronger...
-
How does the adoption of a budget for a general fund entity differ from the adoption of a budget by a commercial unit?
-
Under the current rate method, describe how the various balance sheet accounts are translated (including the equity accounts) and how this translation affects the computation of various ratios (such...
-
How should a transaction gain or loss be reported that is related to an unsettled receivable recorded when the firms inventory was exported?
-
Enthalpy of superheated steam is given by (a) \(h_{g}+c_{p s} \ln \frac{\mathrm{T}_{\text {sup }}}{\mathrm{T}_{s}}\) (b) \(h_{f}+h_{f g}\) (c) \(s_{g}+x s_{f g}\) (d) \(x s_{f}\)
-
What do you understand by the term priming ?
-
Determine the change in internal energy when one \(\mathrm{kg}\) of steam expands from \(10 \mathrm{bar} 300^{\circ} \mathrm{C}\) to 0.5 bar and 0.9 dry. Take \(c_{p s}=2.1 \mathrm{~kJ} /...
Study smarter with the SolutionInn App