Concept explainers
Comprehensive summary problem (Learning Objectives 2 8 3)
Birdhouses Inc. makes backyard birdhouses. The company sells the birdhouses to home improvement stores for $20 per birdfeeder. Each birdhouse requires 2.0 board feet of wood, which the company obtains at a cost of $5 per board foot. The company would like to maintain an ending stock of wood equal to 15% of the next month’s production requirements. The company would also like to maintain an ending stock of finished birdfeeders equal to 10% of the next month’s sales.
Sales data for the company is as follows:
Units | |
October actual sales (prior year) | 72.000 |
November actual sales (prior year) | 84.000 |
December actual sales (prior year) | 91,000 |
January projected sales | 95.000 |
February projected sales | 105,000 |
March projected sales | 110,000 |
April projected sales | 125,000 |
In any given month, 25% of the total sales are cash sales, while the remainder are credit sales.
The company’s collection history indicates that 75% of credit sales is collected in the month after the sale, 15% is collected two months after the sale, 8% is collected three months after the sale, and the remaining 2% is never collected. Assume that the total cost of direct materials purchases in December was $1,001,000. The company pays 60% of its direct materials purchases in the month of purchase and pays the remaining 40% in the month after purchase.
Requirements
- 1. Prepare the following budgets for the first three months of the year, as well as a summary budget for the quarter.
- 2. Prepare the sales budget, including a separate section that details the type of sales made (cash versus credit).
- 3. Prepare the production budget.
- 4. Prepare the direct materials purchases budget. Assume the company needs 242,000 board feet of wood for production in April.
- 5. Prepare the cash collections budget for January, February, and March, as well as a summary for the first quarter.
- 6. 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)
- EA1. Garrison Boutique, a small novelty store, just spent $4,000 on a new software program that will help in organizing its inventory. Due to the steep learning curve required to use the new software, Garrison must decide between hiring two part-time college students or one full-time employee. Each college student would work 20 hours per week and would earn $15 per hour. The full-time employee would work 40 hours per week and would earn $15 per hour plus the equivalent of $2 per hour in benefits. Employees are given two polo shirts to wear as their uniform. The polo-shirts cost Garrison $10 each. What are the opportunity costs for Garrison?arrow_forwardYou 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_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_forward
- Ethical Behavior Consider the following scenario between Dave, a printer, and Steve, an assistant in the local universitys athletic department. Steve: Dave, our department needs to have 10,000 posters printed for the basketball team for next year. Heres the mock-up, and well need them in a month. How much will you charge? Dave: Well, given the costs I have for ink and paper, 1 can come in at around 5,000. Steve: Great, heres what I want you to do. Print me up an invoice for 7,500. Huts our budget. Then, when they pay you, you give me a check for 2,500. Ill make sure that you get the job. Required: CONCEPTUAL CONNECTION Is Steves proposal ethical? What should Dave do?arrow_forwardSHOW 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_forward1. Garrison Boutique, a small novelty store, just spent $4,000 on a new software program that will help in organizing its inventory. Due to the steep learning curve required to use the new software, Garrison must decide between hiring two part-time college students or one full-time employee. Each college student would work 20 hours per week, and would earn $15 per hour. The full-time employee would work 40 hours per week and would earn $15 per hour plus the equivalent of $2 per hour in benefits. Employees are given two polo shirts to wear as their uniform. The polo-shirts cost Garrison $10 each. Software, $4,000 None Shirts, $20 Shirts, $10 Benefits, $80 Benefits, $2 What are the relevant costs, relevant revenues, sunk costs, and opportunity costs for Garrison? PLEASE NOTE: For categories with multiple items from the list above, you will list them in the order in which they are presented in the problem and for the proper dollar amount. Categories: First Item Second Item…arrow_forward
- The Happy Toddlers (THT) is a preparatory school for children three to five years old. There are ten teachers employed by THT: five senior teachers with a salary of P30,000 a month and five junior teachers at P18,000 a month. There are also four administrators with average monthly salary of P35,000. Annual depreciation for furniture and fixtures amounted to P100,000. Utilities starting operation totals P200,000. Required:Examine and list down the expenses of THT as of December 31 by nature. Which type of expense is the highest and lowest? If the owner of THT consulted you on minimizing expenses and maximizing profit, what would you recommend?arrow_forwardThe Happy Toddlers (THT) is a preparatory school for children three to five years old. There are ten teachers employed by THT: five senior teachers with a salary of P30,000 a month and five junior teachers at P18,000 a month. There are also four administrators with average monthly salary of P35,000. Annual depreciation for furniture and fixtures amounted to P100,000. Utilities starting operation totals P200,000.Required:Examine and list down the expenses of THT as of December 31 by nature. Which type of expense is the highest and lowest?If the owner of THT consulted you on minimizing expenses and maximizing profit, what would you recommend?arrow_forwardYour friend, Suzie Chang, has designed a new type of outdoor toy that helps children learn basic concepts such as colors, numbers, and shapes. Suzie’s product will target two groups: day care centers in warm climates and home school programs. Her company is Jiffy Jet and costs for last month follow. Factory rent $ 3,140 Company advertising 1,080 Wages paid to assembly workers 31,800 Depreciation for salespersons’ vehicles 2,140 Screws 585 Utilities for factory 890 Assembly supervisor’s salary 3,510 Sandpaper 190 President’s salary 5,050 Plastic tubing 4,200 Paint 250 Sales commissions 1,310 Factory insurance 1,150 Depreciation on cutting machines 2,020 Wages paid to painters 8,300 Assume that Suzie Chang has decided to begin production of her outdoor children’s toy. Required: 3. Determine the total cost for each of the following:arrow_forward
- Wee Care is a nursery school for pre-kindergarten children. The school has determined that the following biweekly revenues and costs occur at different levels of enrollment Number of Students Enrolled Total Revenue Total Costs: $3,000 $2,100 4,500 2,700 4,800 2,800 6,000 3,200 6,300 3,255 The average cost per student when 16 students enroll in the school is 10 15 16 20 21 Select one: O a $100. O b. $125, C. $175. O d. $300. Oe. $400. Clear my choice Next pagarrow_forwardYour friend, Suzie Whitson, has designed a new type of outdoor toy that helps children learn basic concepts such as colors, numbers, and shapes. Suzie’s product will target two groups: day care centers in warm climates and home school programs. Her company is Jiffy Jet and costs for last month follow: Factory rent $ 3,050 Company advertising 1,170 Wages paid to assembly workers 31,200 Depreciation for salespersons’ vehicles 2,100 Screws 510 Utilities for factory 825 Assembly supervisor’s salary 3,520 Sandpaper 160 President’s salary 5,040 Plastic tubing 4,090 Paint 240 Sales commissions 1,240 Factory insurance 1,150 Depreciation on cutting machines 2,140 Wages paid to painters 7,900 Assume that Suzie Whitson has decided to begin production of her outdoor children’s toy. Required:1 and 2. Identify each of the preceding costs as either a product or a period cost. If the cost is a product cost, decide whether it…arrow_forwardPLEASE ONLY ANSWER QUESTIONS 2,3 AND 4 Alameda Tile sells products to many people remodeling their homes and thinks that it could profitably offer courses on tile installation, which might also increase the demand for its products. The basic installation course has the following (tentative) price and cost characteristics. Tuition $ 430 per student Variable costs (tiles, supplies, and so on) 240 per student Fixed costs (advertising, salaries, and so on) 91,200 per year Required: a. What enrollment will enable Alameda Tile to break even? b. How many students will enable Alameda Tile to make an operating profit of $51,300 for the year? c. Assume that the projected enrollment for the year is 840 students for each of the following (considered independently): 1. What will be the operating profit (for 840 students)? 2. What would be the operating profit if the tuition per student (that is, sales price) decreased by 5 percent? Increased by 22 percent? 3.…arrow_forward
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning