We are considering altering our gourmet cake line. This is the information for just that line....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
We are considering altering our gourmet cake line. This is the information for just that line. It currently sells for $40 each. Sales are 60% cash and 40% on credit. All credit sales are collected in the month following the sale. At March 31, the balance in accounts receivable is $12,000, which represents the uncollected balance on March sales. Budgeted sales for the next four months follow: Sales in units.. The product cost is $20 per unit, and desired ending inventory is 60% of the following month's sales in units. Inventory at March 31 is 480 units. Purchases are paid 50% in the month of purchase and 50% in the following month. At March 31, the balance in accounts payable is $11,000, which represents the unpaid purchases from March. Operating expenses are paid in the month incurred and consist of: April May June July 800 1,000 600 1,200 Commissions (10% of sales) Shipping (3% of sales) . Depreciation is $2,000 per month. Income taxes are 40%, and will be paid on July 1. There are no taxes payable at March 31. A minimum cash balance of $12,000 is required, and the beginning cash balance is $12,000. Loans are obtained at the end of any month when a cash shortage occurs. Interest is 1% per month based on the beginning of the month loan balance and is paid at each month end. If an excess balance of cash exists, loans are repaid at the end of the month. At March 31, the loan balance is $2,000. Prepare a master budget (round all dollar amounts to the nearest whole dollar) for each of the months of April, May, and June that includes the: Sales budget Merchandise purchases budget Miscellaneous expenses budget Budgeted income statement Office salaries ($3,000 per month) Rent ($5,000 per month) . Table of cash receipts Cash payments budget for inventory purchases Cash budget, including loan information We are considering altering our gourmet cake line. This is the information for just that line. It currently sells for $40 each. Sales are 60% cash and 40% on credit. All credit sales are collected in the month following the sale. At March 31, the balance in accounts receivable is $12,000, which represents the uncollected balance on March sales. Budgeted sales for the next four months follow: Sales in units.. The product cost is $20 per unit, and desired ending inventory is 60% of the following month's sales in units. Inventory at March 31 is 480 units. Purchases are paid 50% in the month of purchase and 50% in the following month. At March 31, the balance in accounts payable is $11,000, which represents the unpaid purchases from March. Operating expenses are paid in the month incurred and consist of: April May June July 800 1,000 600 1,200 Commissions (10% of sales) Shipping (3% of sales) . Depreciation is $2,000 per month. Income taxes are 40%, and will be paid on July 1. There are no taxes payable at March 31. A minimum cash balance of $12,000 is required, and the beginning cash balance is $12,000. Loans are obtained at the end of any month when a cash shortage occurs. Interest is 1% per month based on the beginning of the month loan balance and is paid at each month end. If an excess balance of cash exists, loans are repaid at the end of the month. At March 31, the loan balance is $2,000. Prepare a master budget (round all dollar amounts to the nearest whole dollar) for each of the months of April, May, and June that includes the: Sales budget Merchandise purchases budget Miscellaneous expenses budget Budgeted income statement Office salaries ($3,000 per month) Rent ($5,000 per month) . Table of cash receipts Cash payments budget for inventory purchases Cash budget, including loan information
Expert Answer:
Answer rating: 100% (QA)
Sales Budget Req A April May June Quarter April May June Sales units 800 1000 600 2400 Sales price per unit 40 40 40 40 Total budgeted sales 32000 400... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
What tools and resources do scientists use to construct phylogenetic trees ?
-
TFS Corporation, a retail company selling hotel furniture, has just completed its master budget for the next fiscal year. Ending inventory is budgeted at 20% of cost of goods available for sale....
-
The current stock price of Well-Tempered Flugelhorns (WTF) is $40 with an instantaneous standard deviation of 20%. If the risk-free rate is 3%, what is the value of a put option with an exercise...
-
On the cost of goods manufactured schedule, depreciation onfactory equipment... A. is not listed because it is not a product cost. B. is not an inventoriable cost. C. is not listed because it is...
-
A shaft is turning at 65.0 rad/s at time t = 0. Thereafter, its angular acceleration is given by where t is the elapsed time. a = 10.0 rad/s2 5.00t rad/s3, (a) Find its angular speed at t = 3.00 s....
-
Turn back to Figure 2.9 and look at the Apple options. Suppose you buy an August expiration call option with exercise price $355. a. If the stock price in August is $367, will you exercise your call?...
-
The mean room and board expense per year at four-year colleges is \($10,453\). You randomly select 9 four-year colleges. What is the probability that the mean room and board is less than \($10,750?\)...
-
Cool Sky reports the following costing data on its product for its first year of operations. Year, the company produced 44,000 units and sold 36,000 units at a price of $140 per unit. Manufacturing...
-
What causes the different fracture types in an unreinforced concrete cylinder test? What gives a cone, or a cone and split, or cone and shear, ect.
-
Niagara Dairy is a boutique cheese maker based in the Niagara region of Ontario. Over the years, the business has grown by supplying local retailers and, eventually, by exporting cheese products. In...
-
1. Mona is a type of "Y " generation or millennial generation which uses and familiar with communications, media, and digital technologies. All day at work she loves to surf the web, email, chat and...
-
Define the major items on the assets and liabilities sides of a banks balance sheet. If a bank has $100 million in assets and $80 million in liabilities, what is the banks net worth? What is credit...
-
A. Consider an at-the-money (ATM) short straddle position (i.e. a position obtained by selling an equal number of put and call options with the same strike price). a scenario in which underlying...
-
Earth Enterprises began the year 2020 with total stockholders' equity of $2,400,000. Its net income for 2020 was $640,000, and $106,800 of dividends were declared. Earth Enterprises had no other...
-
On March 20, Microsoft agrees to a swap with a notional principal of $100M. Payments are exchanged every 6 months. Microsoft agrees to pay an interest rate of 5% per annum with semiannual compounding...
-
Barbara wants to save up enough money to put a $24,000 down payment on a house in 2 years. How much money should she deposit each month into an account which pays 6% interest compounded monthly in...
-
To combat terrorist financing, what needs to be in place? O Intergovernmental commitment A trade embargo O Legislation a and c only
-
When the concentration of a strong acid is not substantially higher than 1.0 10-7 M, the ionization of water must be taken into account in the calculation of the solution's pH. (a) Derive an...
-
Bev and Ken Hair have been married for 3 years. They live at 3567 River Street, Springfield, MO 63126. Ken is a full-time student at Southwest Missouri State University (SMSU) and Bev works as an...
-
Walter, a single taxpayer, purchased a limited partnership interest in a tax shelter in 1985. He also acquired a rental house in 2012, which he actively manages. During 2012, Walter's share of the...
-
Ken paid the following amounts for interest during 2012: Qualified interest on home mortgage...........................................$4,700 Auto loan...
-
Maribel Ortiz is puzzled. Her company had a profit margin of 10% in 2025. She feels that this is an indication that the company is doing well. Gordon Liddy, her accountant, says that more information...
-
At December 31, 2025, the fair value of non-trading securities is 41,300 and the cost is 39,800. At January 1, 2025, there was a credit balance of 900 in the Fair Value Adjustment Non-Trading...
-
On January 1, 2025, Lennon Enterprises acquires 100% of Ono Ltd. for 220,000 in cash. The condensed statements of financial position of the two companies immediately following the acquisition are as...
Study smarter with the SolutionInn App