Concept explainers
Comprehensive summary problem (Learning Objectives 2 & 3)
Birdfeeders Unlimited makes backyard birdfeeders. The company sells the birdfeeders to home improvement stores for $15 per birdfeeder. Each birdfeeder requires 1.5 board feet of wood, which the company obtains at a cost of $4 per board foot. The company would like to maintain an ending stock of wood equal to 10% of the next month’s production requirements. The company would also like to maintain an ending stock of finished birdfeeders equal to 20% of the next month’s sales.
Sales data for the company is as follows:
Units | |
October actual sales (prior year) | 92.000 |
November actual sales (prior year) | 85.000 |
December actual sales (prior year) | 78.000 |
January projected sales | 80.000 |
February projected sales | 90.000 |
March projected sales | 95.000 |
April projected sales | 105,000 |
In any given month, 20% of the total sales are cash sales, while the remainder are credit sales. The company’s collection history indicates that 80% of credit sales is collected in the month after the sale, 10% is collected two months after the sale, 6% is collected three months after the sale, and the remaining 4% is never collected.
Assume that the total cost of direct materials purchases in December was $550,000. The company pays 45% of its direct materials purchases in the month of purchase and pays the remaining 55% in the month after purchase.
Requirements
Prepare the following budgets for the first three months of the year, as well as a summary budget for the quarter:
- 1. Prepare the sales budget, including a separate section that details the type of sales made (cash versus credit).
- 2. Prepare the production budget.
- 3. Prepare the direct materials purchases budget. Assume the company needs 120,000 board feet of wood for production in April.
- 4. Prepare the cash collections budget for January, February, and March, as well as a summary for the first quarter.
- 5. Prepare the
cash payments budget for direct materials purchases for the months of January, February, and March, as well as a summary for the first quarter.
Want to see the full answer?
Check out a sample textbook solutionChapter 9 Solutions
Managerial Accounting (5th Edition)
- SHOW WORKING PLEASE . NO HANDWRITING The School Book Shop sells T Shirts emblazoned with the school’s name and logo. Theshirts cost $2,000 each and management estimates that 900 T Shirts will be sold during each month ofthe year. The annual holding cost for a unit of that inventory is estimated to be 1.5% of the purchaseprice. It costs the Book Shop $500 to place a single order.The maximum sale for the Book Shop for any one week is 300 shirts and minimum sales 150shirts. The supplier takes anywhere from 2 to 4 weeks to deliver the merchandise after the order isplaced.i) Determine the highest number of shirts that should be purchased by the Gift Shop in order tominimize stock administration cost.ii) What is the total stock administration costs?iii)Using the EOQ policy, determine the re-order level, minimum inventory level and maximuminventory level for the T Shirts.arrow_forwardSmart Strike Company manufactures and sells soccer balls for teams of children in elementary and high school. Smart Strike's best-selling lines are the practice ball line (durable soccer balls for training and practice) and the match ball line (high-performance soccer balls used in games). In the first four months of next year, Smart Strike expects to sell the following: Practice Balls Match Balls Units Selling Price Units Selling Price January 50,000 $8.25 7,000 $16.00 February 58,000 $8.25 7,500 $16.00 March 80,000 $8.25 14,000 $16.00 April 100,000 $8.25 18,000 $16.00 Required: 1. Construct a sales budget for Smart Strike for the first three months of the coming year. Show total sales for each product line by month and in total for the first quarter. If required, round your answers to the nearest cent. Smart Strike CompanySales BudgetFor the First Quarter of Next Year January February March Quarter Practice ball: Units ____ ____ _____…arrow_forwardmart Strike Company manufactures and sells soccer balls for teams of children in elementary and high school. Smart Strike's best-selling lines are the practice ball line (durable soccer balls for training and practice) and the match ball line (high-performance soccer balls used in games). In the first four months of next year, Smart Strike expects to sell the following: Practice Balls Match Balls Units Selling Price Units Selling Price January 47,000 $8.60 6,600 $17.10 February 61,000 $8.60 7,700 $17.10 March 86,000 $8.60 13,500 $17.10 April 105,000 $8.60 17,000 $17.10 Smart Strike requires ending inventory of product to equal 20 percent of the next month's unit sales. Beginning inventory in January was 9,400 practice soccer balls and 1,320 match soccer balls. Every practice ball requires 0.7 square yard of polyvinyl chloride panels, one bladder with valve (to fill with air), and 3 ounces of glue. Smart Strike's policy is that 20…arrow_forward
- You run a business out of your dorm room selling ACC2020 textbooks in both paper and digital versions. The paper version costs you $400 and you can sell it for $600. The digital version costs you $100 and you can sell it for $200. Last semester you sold 10 paper versions and 100 digital versions for total sales of $26,000. You expect that sales mix will continue this semester. - If your semester fixed costs are $6,000 for a publisher's license, what dollar amount of sales will you need to breakeven? - How many paper and digital books will you have to sell to break even? - How much operating income did you have last semester?arrow_forwardSmart Strike Company manufactures and sells soccer balls for teams of children in elementary and high school. Smart Strike's best-selling lines are the practice ball line (durable soccer balls for training and practice) and the match ball line (high-performance soccer balls used in games). In the first four months of next year, Smart Strike expects to sell the following: Practice Balls Match Balls Units Selling Price Units Selling Price January 48,000 $8.85 6,400 $17.20 February 58,000 $8.85 7,500 $17.20 March 86,000 $8.85 13,000 $17.20 April 105,000 $8.85 17,000 $17.20 Smart Strike requires ending inventory of product to equal 20 percent of the next month's unit sales. Beginning inventory in January was 9,600 practice soccer balls and 1,280 match soccer balls. Every practice ball requires 0.7 square yard of polyvinyl chloride panels, one bladder with valve (to fill with air), and 2 ounces of glue. Smart Strike's policy is that 20…arrow_forwardInstruction: Please answer the following with complete solution and explanation. Thank you! 1. Summer Company offers a set of building blocks to customers who send in three (3) UPC codes from Summer cereal, along with P50.00. The blocks sets cost Summer P110 each to purchase and P60 each to mail to customers. During 20x1, Summer sold 1,000,000 boxes of cereal. The company expects 30% of the UPC codes to be sent in. During 20x1, 120,000 UPC codes are redeemed. Required: 1. What is the cost of estimated claims outstanding? 2. Prepare Summer’s December 31, 20x1 adjusting entry.arrow_forward
- A University produces two courses for its Management students this year. MATA32 and MATA33. Each student taking MATA32 requires 6 hours of teaching, 2 hours of adminis- tration, with a revenue of $1300. Each student taking MATA33 requires 7 hours of teaching, 1 hour of administration with a revenue of $1700. Due to the University's resources, there is a maximum of 2010 teaching hours and 150 administration hours. The University must also admit at least 30 MATA32 and at least 30 MATA33 students due to government regulation. What is the maximum revenue? (A) 90000 (B) 129000 (C) 188000 (D) 192500 (E) None of the abovearrow_forward13. Micromedia offers computer training seminars on a variety of topics. In the seminars each student works at a personal computer, practicing the particular activity that the instructor is presenting. Micromedia is currently planning a two-day seminar on the use of Microsoft Excel in statistical analysis. The projected fee for the seminar is $600 per student. The cost for the conference room, instructor compensation, lab assistants, and promotion is $9600. Micromedia rents computers for its seminars at a cost of $60 per computer per day. a. Develop a model for the total cost to put on the seminar. Let x represent the number of students who enroll in the seminar. b. Develop a model for the total profit if x students enroll in the seminar. e. Micromedia has forecasted an enrollment of 30 students for the seminar. How much profit will be earned if its forecast is accurate? d. Compute the breakeven point.arrow_forwardSmart Company manufactures and sells soccer balls for teams of children in elementary and high school. Smart best-selling lines are the practice ball line (durable soccer balls for training and practice) and the match ball line (high-performance soccer balls used in games). In the first four months of next year, Smart expects to sell the following: Practice BaseBalls Match BaseBalls Units Selling Price Units Selling Price January 48,000 $8.85 6,400 $17.20 February 58,000 $8.85 7,500 $17.20 March 86,000 $8.85 13,000 $17.20 April 105,000 $8.85 17,000 $17.20 Smart requires ending inventory of product to equal 20 percent of the next month's unit sales. Beginning inventory in January was 9,600 practice soccer balls and 1,280 match soccer balls. Every practice ball requires 0.7 square yard of polyvinyl chloride panels, one bladder with valve (to fill with air), and 2 ounces of glue. Smart Strike's policy is that 20 percent of the following…arrow_forward
- Smart Strike Company manufactures and sells soccer balls for teams of children in elementary and high school. Smart Strike's best-selling lines are the practice ball line (durable soccer balls for training and practice) and the match ball line (high-performance soccer balls used in games). In the first four months of next year, Smart Strike expects to sell the following: Practice Balls Match Balls Units Selling Price Units Selling Price January 47,000 $8.55 6,700 $16.80 February 61,000 $8.55 7,600 $16.80 March 81,000 $8.55 13,500 $16.80 April 100,000 $8.55 16,000 $16.80 Smart Strike requires ending inventory of product to equal 20 percent of the next month's unit sales. Beginning inventory in January was 9,400 practice soccer balls and 1,340 match soccer balls. Every practice ball requires 0.7 square yard of polyvinyl chloride panels, one bladder with valve (to fill with air), and 3 ounces of glue. Smart Strike's policy is that 20…arrow_forwardA textbook publisher produces a textbook for $25 per book and sells 160 books to the Campus Bookstore for $50 per unit. The bookstore sells the textbook new for $75 and used for $60. This edition of the book is used for 2 years (4 semesters). The book-store sells all textbooks that it has at the beginning each semester, and it repurchases 50% of those at the end of each semester for $30. What is the sales income over the life of this 160-unit lot of textbooks? A $16,800 OB. $11,600 OC.$11,900 OD. $14,000 E. None of the given answers are correct.arrow_forwardE7-37A Comprehensive CVP analysis (Learning Objectives 1, 2, 3, 4, & 5) Marcus Allen is evaluating a business opportunity to sell premium car wax at vinta cost of $29 per tub. He plans to sell the premium wax for $84 per tub. He estimates fixed shows. The wax is sold in 64-ounce tubs. Marcus can buy the premium wax at a wholesale costs such as travel costs, booth rental cost, and lodging to be $880 per car show Requirements 1. Determine the number of tubs Marcus must sell per show to break even. 2. Assume Marcus wants to earn a profit of $1,320 per show. a. Determine the sales volume in units necessary to earn the desired profit. b. Determine the sales volume in dollars necessary to earn the desired profit. c. Using the contribution margin format, prepare an income statement (condensed version) to confirm your answers to parts a and b. 3. Determine the margin of safety between the sales volume at the breakeven point and the sales volume required to earn the desired profit. Determine…arrow_forward
- 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