Survey Of Accounting
5th Edition
ISBN: 9781259631122
Author: Edmonds, Thomas P.
Publisher: Mcgraw-hill Education,
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 14, Problem 22P
Problem 7-22A Preparing budgets with multiple products
Jasper Fruits Corporation wholesales peaches and oranges. Barbara Jasper is working with the company’s accountant to prepare next year’s budget. Ms. Jasper estimates that sales will increase 5 percent for peaches and 10 percent for oranges. The current year’s sales revenue data follow:
First Quarter | Second Quarter | Third Quarter | Fourth Quarter | Total | |
Peaches | $ 80,000 | $100,000 | $160,000 | $140,000 | $ 480,000 |
Oranges | 200,000 | 225,000 | 285,000 | 190,000 | 900,000 |
Total | $280,000 | $325,000 | $445,000 | $330,000 | $1,380,000 |
Based on the company’s past experience, cost of goods sold is usually 60 percent of sales revenue. Company policy is to keep 10 percent of the next period’s estimated cost of goods sold as the current period’s ending inventory. (Hint: Use the cost of goods sold for the first quarter to determine the beginning inventory for the first quarter.)
Required
- a. Prepare the company’s sales budget for the next year for each quarter by individual product.
- b. If the selling and administrative expenses are estimated to be $350,000, prepare the company’s
budgeted annual income statement. - c. Ms. Jasper estimates next year’s ending inventory will be $10,000 for peaches and $20,000 for oranges. Prepare the company’s inventory purchases budgets for the next year, showing quarterly figures by product.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Problem #6: Operating Budgets
Cathy’s Cookies produces cookies for resale at local grocery stores. The company is currently in the process of establishing a master budget on a quarterly basis for this coming fiscal year, which ends December 31. Prior year quarterly sales were as follows (1 unit = 1 batch):
First quarter: 8,000 units
Second quarter: 9,600 units
Third quarter: 12,000 units
Fourth quarter: 10,400 units
Unit sales are expected to increase 20%, and each unit is expected to sell for $5. Management prefers to maintain ending finished goods inventory equal to 15% of next quarter's sales. Assume finished goods inventory at the end of the fourth quarter budget period is estimated to be 2,000 units.
Required:
1) Prepare a sales budget for Cathy’s Cookies.
(2) Prepare a production budget for Cathy’s Cookies.
(3) What can you interpret about Cathy’s Cookies Sales Budget? Trends?
Problem 7-17A (Algo) Preparing a sales budget and schedule of cash receipts LO 7-2
Thornton Pointers Corporation expects to begin operations on January 1, year 1, it will operate as a specialty sales company that sells
laser pointers over the Internet. Thornton expects sales in January year 1 to total $400,000 and to increase 20 percent per month in
February and March. All sales are on account. Thornton expects to collect 66 percent of accounts receivable in the month of sale, 24
percent in the month following the sale, and 10 percent in the second month following the sale.
Required
a. Prepare a sales budget for the first quarter of year 1.
b. Determine the amount of sales revenue Thornton will report on the year 1 first quarterly pro forma income statement.
c. Prepare a cash receipts schedule for the first quarter of year 1.
d. Determine the amount of accounts receivable as of March 31, year 1.
Complete this question by entering your answers in the tabs below.
Required A Required B…
Question 2
A. The Rilex and Chill Coffee Shop has requested a cash budget for August. After
examining the records of the company, you find the following:
1.
Cash balance on 1 August is RM43,280.
2. Actual sales for June and July are as follows:
June
RM
Cash sales
Credit sales
Total sales
10,200
26,100
36,300
July
RM
14,700
33,900
48,600
3. Credit sales are collected over three months: 30% in the month of sales, 40% in the
second month, and 25% in the third month. The customers who paid in the month of
sales are qualified for 3% discounts on the amount owed. While the sales collected in the
third month are subject to a 2% late fee, which is paid by those customers in addition to
what they owe. The remaining sales are uncollectible.
4. Inventory purchases average 80% of a month's total sales. Of those purchases, 60% are
paid for in the month of purchase. The remaining 40% is paid for in the following month.
5.
Salaries and wages total RM13,800 per month.
6. The company received interest…
Chapter 14 Solutions
Survey Of Accounting
Ch. 14 - Prob. 1QCh. 14 - Prob. 2QCh. 14 - 3.What are the three levels of planning? Explain...Ch. 14 - 4.What is the primary factor that distinguishes...Ch. 14 - 5.What is the advantage of using a perpetual...Ch. 14 - Prob. 6QCh. 14 - Prob. 7QCh. 14 - 8. Ken Shilov, manager of the marketing...Ch. 14 - Prob. 9QCh. 14 - 10.What is the normal starting point in developing...
Ch. 14 - 11. How does the level of inventory affect the...Ch. 14 - 12.What are the components of the cash budget?...Ch. 14 - 13.The primary reason for preparing a cash budget...Ch. 14 - 14.What information does the pro forma income...Ch. 14 - 15.How does the pro forma statement of cash flows...Ch. 14 - Exercise 7-1A Budget responsibility Teresa...Ch. 14 - Exercise 7-2A Preparing a sales budget Parliament...Ch. 14 - Prob. 3ECh. 14 - Exercise 7-4A Preparing sales budgets with...Ch. 14 - Exercise 7-5A Determining cash receipts from...Ch. 14 - Exercise 7-6A Using judgment in making a sales...Ch. 14 - Exercise 7-7A Preparing an inventory purchases...Ch. 14 - Exercise 7-8A Preparing a schedule of cash...Ch. 14 - Exercise 7-9A Determining the amount of expected...Ch. 14 - Exercise 7-10A Preparing inventory purchases...Ch. 14 - Exercise 7-11A Preparing a schedule of cash...Ch. 14 - Prob. 12ECh. 14 - Exercise 7-13A Preparing a cash budget The...Ch. 14 - Exercise 7-14A Determining amount to borrow and...Ch. 14 - Prob. 15ECh. 14 - Problem 7-16A Behavioral impact of budgeting...Ch. 14 - Prob. 17PCh. 14 - Problem 7-18A Preparing an inventory purchases...Ch. 14 - Prob. 19PCh. 14 - Problem 7-21A Preparing a cash budget Fayette...Ch. 14 - Prob. 21PCh. 14 - Problem 7-22A Preparing budgets with multiple...Ch. 14 - Problem 7-23A Preparing a master budget for retail...Ch. 14 - ATC 7-1 Business Applications Case Preparing and...Ch. 14 - ATC7-2 Group Assignment Master budget and pro...Ch. 14 - ATC 7-4 Writing Assignment Continuous budgeting...Ch. 14 - Ethical Dilemma Bad budget system or unethical...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Exercise 4-26 Millet Corporation manufactures and sells stuff toys. She is busy with the third and fourth quarters of 2021 at the moment. She asks your help to prepare some of these budgets: The sales budget in units is as follows: Third quarter Fourth quarter 45,000 pieces 70,000 pieces 140 It is decided that stuff toys inventories are to be 20,000 picces at the end of the third quarter, and 5,000 pieces at the end of the fourth quarter. The inventory at the start of the third quarter will consist of 8,000 stuff toys. Each stuff toy is packaged in a colorful cardboard box, and contains 2 units of Material A and 5 units of Material B. The inventory of materials at the beginning of the third quarter will be: 125,000 pieces 15,000 units Воxes Material A Material B 45,000 units There are sufficient boxes on hand for both quarters; none will be purchased during the two periods. Material A can be bought whenever needed and in any quantity desired. The starting inventory of 15,000 units is…arrow_forwardProblem 6 Tomtom store seeks your assistance to develop cash and other budget information for May, June, and July 2009. On April 30, 2009, the company had cash balance of Php5,500. The budget is based on the following assumptions: A. Sales 1. Each month's sales are billed on the last day of the month 2. Customers are allowed 3% discount if payment is made within 10 days after the billing date. Accounts receivable are booked gross. 3. Sixty percent of the billings are collected within the discount period, 25% are collected by the end of the month where discount period is allowed, 9% are collected by the end of the end second month, and 6% prove uncollectible. B. Purchases 1. 54% of all purchases of materials and selling, general and administrative expenses are paid at the month purchased and the remainder in the following month. 2. Each month's unit of ending inventory is equal to 130% of the month's units of sales. 3. The cost of each unit of inventory is P20. 4. Selling, general and…arrow_forwardPlease answer both the requirement correctly Silver Company makes a product that is very popular as a Mother’s Day gift. Thus, peak sales occur in May of each year, as shown in the company’s sales budget for the second quarter given below: April May June Total Budgeted sales (all on account) $420,000 $620,000 $240,000 $1,280,000 From past experience, the company has learned that 20% of a month’s sales are collected in the month of sale, another 65% are collected in the month following sale, and the remaining 15% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $350,000, and March sales totaled $380,000. Required: 1. Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. 2. What is the accounts receivable balance on June 30th?arrow_forward
- 7:50 Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur in May of each year, as shown in the company's sales budget for the second quarter given below: Required 1 Budgeted sales (all on account) From past experience, the company has learned that 25% of a month's sales are collected in the month of sale, another 60% are collected in the month following sale, and the remaining 15% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $320,000, and March sales totaled $350,000. Complete this question by entering your answers in the tabs below. Required: 1. Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. 2. What is the accounts receivable balance on June 30th? Required 2 February sales March sales April $390,000 April sales May sales June sales Total cash collections Prepare a schedule of expected cash collections from…arrow_forwardChapter 5 - Planning Budgets Problem 5.1: The Executive Committee of the West Company has gathered to pay homage to the founder and to discuss the upcoming 3rd Quarter budget. The marketing department has provided the following sales budget: 2nd Quarter: Actual results 3rd Quarter: Budget 4th Quarter: Budget April 4,000 July August 4,800 Sept Oct Мay 3,500 June Nov Sales - Units 5,000 6,000 5,600 4,200 2,500 Sale - Price $5.00 $5.00 $5.00 $5.00 $5.00 $5.00 $5.00 $5.00 Sales - Total ($s) $20,000 $17,500 $25,000 $30,000 $24,000 $28,000 $21,000 $12,500 Additional information: Required ending inventory levels: Finished goods (production) – 10.00%; Raw materials – 15.00%. Scrap rates: Production – 10.00%; Raw materials – 5.00% Units of raw materials required for each finished unit: 6 pounds Cash sales: Of the total sales in the above sales budget, on average 5% are cash sales with the remainder being credit sales. Credit sales typically are collected as follows: Month of sale – 30.00%, 1st…arrow_forwardMake a Decision Nonmanufacturing Staffing Budgets MAD 8-1 Analyze Johnson Stores' staffing budget for holidays Obj. 6 Johnson Stores is planning its staffing for the upcoming holiday season. From past history, the store determines that it needs one additional sales clerk for each $12,000 in daily sales. The average daily sales is anticipated to increase by $96,000 from Black Friday until Christmas Eve. or 27 shopping days. Each additional sales clerk will work an eight-hour shift and will be paid $14 per hour. a. Determine the amount to budget for additional sales clerks for the holiday season. b. If Johnson Stores has an average 40% gross profit on sales, should it add the staff suggested by your answer in (a)? That is, is it profitable to staff for the increased sales in (a)?arrow_forward
- eco Exercise 4-26 veco some of these budgets: veco The sales budget in units is as follows: eco Third quarter 45,000 pieces Fourth quarter 70,000 pieces Each stuff toy is packaged in a colorful cardboard box, and contains 2 units of Material A and 5 units of Material B. The inventory of materials at the beginning of the third quarter will be: Boxes 125,000 pieces Material A 15,000 units 45,000 units Material B There are sufficient boxes on hand for both quarters; none will be purchased during the two periods. eco Material A can be bought whenever needed and in any quantity desired. The starting inventory of 15,000 units is considered to be an ideal quantity. Material B must be purchased in quantities of 10,000 units, or multiples of 10,000. It is desired that at the end of the third and fourth quarters, a minimum quantity of 30,000 units be on hand, or as close thereto as the standard quantity will permit. REQUIRED: 1. Prepare a production budget for the third and fourth quarters of…arrow_forwardPRACTICE 1 •A company is preparing for a monthly sales budget for Jan, Feb, & Mar. Sales are 100% on credit. Credit sales for Jan, Feb, and Mar are $140, $180, and $160, respectively. Cash collections are made in - the month of sale: 50% - a month after sale: 30% - two month after sale: 15% - uncollectible: 5% (recognized in the month of sale) Q1. Total cash collection in March? Q2. If the budgeted EB of net A/R on 12/31 is $120 and the budgeted total cash collection in Feb is $162, how much is the total credit sales in November? PRACTICE 2 •A company provides data regarding its operations as follows. •Sales Budget (100% on credit): November: $400,000, December: $375,000, January: $420,000 •Cash collection schedule: Month of sale: 70%, Next Month: 27%, Uncollectible: $3% •The cost of goods sold is 50% of sales. •Monthly depreciation is $15,000. •Other monthly expenses to be paid in cash are $25,000. •60% of the RM purchase is paid for in the month of purchase, the…arrow_forward5. Question Content Area Cash Budget Janet Wooster owns a retail store that sells new and used sporting equipment. Janet has requested a cash budget for October. After examining the records of the company, you find the following: Cash balance on October 1 is $1,110. Actual sales for August and September are as follows: August September Cash sales $6,000 $4,500 Credit sales 59,000 61,000 Total sales $65,000 $65,500 Credit sales are collected over a three-month period: 40 percent in the month of sale, 36 percent in the next month, and 22 percent in the second month after the sale. The remaining sales are uncollectible. Inventory purchases average 70 percent of a month’s total sales. Of those purchases, 45 percent are paid for in the month of purchase. The remaining 55 percent are paid for in the following month. Salaries and wages total $3,850 per month. Rent is $3,150 per month. Taxes to be paid in October are $1,635. Janet…arrow_forward
- PROBLEM 7-I CASH BUDGET The Francine Company, a merchandising firm, has planned the following sales for the next four months: March April Мay June Total budgeted sales..... 50,000 70,000 90,000 60,000 Sales are made 40% for cash and 60% on account. From experience, the company has learned that a month's sales on account are collected according to the following pattern: Month of sale 70% First month following month of sale 20% Second month following month of sale 8% Uncollectible 2% The company requires a minimum cash balance of $4,000 to start a month. Required: A. Compute the budgeted cash receipts for June. B. Assume the following budgeted data for June: Purchases. P52,000 Selling and administrative expenses.... 10,000 Depreciation 8,000 Equipment purchases. 15,000 Cash balance, beginning of June. 6,000 Using this data, along with your answer to part (1) above, prepare a cash budget in good form for June. Clearly show any borrowing needed during the month. The company can borrow in…arrow_forwardPROBLEM 7-I CASH BUDGET The Francine Company, a merchandising firm, has planned the following sales for the next four months: March April May June Total budgeted sales.... 50,000 70,000 90,000 60,000 Sales are made 40% for cash and 60% on account. From experience, the company has learned that a month's sales on account are collected according to the following pattern: Month of sale 70% First month following month of sale 20% Second month following month of sale 8% Uncollectible 2% The company requires a minimum cash balance of $4,000 to start a month. Required: A. Compute the budgeted cash receipts for June.arrow_forwardb. a. Prepare a schedule of cash payments for Fein Company for the month of August. OBJECTIVE 3 C. Exercise 9-45 Cash Budget The owner of a building supply company has requested a cash budget for June. After examining the records of the company, you find the following: Cash balance on June 1 is R7,360. b. Actual sales for April and May are as follows: d. F. a. April May Cash sales R180,000 Credit sales to 00 R530,000 Total sales R389,000 c. Credit sales are collected over a three-month period: R 40% in the month of sale, 30% in the second month, and 20% in the third month. The sales collected in the third month are subject to a 2% late fee, which is paid by those customers in addition to what they owe. The remaining sales are uncollectible. d. Inventory purchases average 64% of a month's total B sales. Of those purchases, 20% are paid for in the month of purchase. The remaining 80% are paid for in the following month. Salaries and wages total R117,500 per month, including a R45,000…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education
What is variance analysis?; Author: Corporate finance institute;https://www.youtube.com/watch?v=SMTa1lZu7Qw;License: Standard YouTube License, CC-BY