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 - With Helios Access
- 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_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_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 loarrow_forward
- Camp Rainbow offers overnight summer camp programs for children ages 10–14 every summer during June and July. Each camp session is one week and can accommodate up to 200 children. The camp is not coed, so boys attend during the odd-numbered weeks and girls attend during the even-numbered weeks. While at the camp, participants make crafts, participate in various sports, help care for the camp’s resident animals, have cookouts and hayrides, and help assemble toys for local underprivileged children.The camp provides all food as well as materials for all craft classes and the toys to be assembled. One cabin can accommodate up to 10 children, and one camp counselor is assigned to each cabin. Three camp managers are on-site regardless of the number of campers enrolled.Following is the cost information for Camp Rainbow’s operations last summer: Week Number of Campers Cost to Run Camp 1 162 $11,070 2 158 11,600 3 144 10,600 4 180 13,730 5 92 9,000 6 192 13,750 7 96 8,090 8…arrow_forward(J) Citations are required for this exercise. Comments to other students must be detailed and substantive. Alpaca Industries, located in the beauty pacific Northwest, manufactures a household electronic device. The company is fairly small with revenues and total assets of approximately $370,000 and $300,000, respectively. The company has never maintained a budget since its inception, and as a new hire, you are eager to create a budget for the company. Write a 1-page memo, explaining to the owner the advantages of budgeting. In your memo, provide exact page number citations. Please note that any responses without citations will not be graded. Only the original responses are graded; subsequent edits are not graded.arrow_forwardClassify costs and make a quality-initiative decision (Learning Objective 5) Sinclair Corp. manufactures radiation-shielding glass panels . Suppose Sinclair is consider-ing spending the following amounts on a new TOM program :Strength-testing one item from each batch of panels ......................... . Training employees in TOM ................................................................. . Training suppliers in TOM .................................................................... . Identifying preferred suppliers that commit to on-time delivery ofperfect quality materials ................................................................... .Sinclair expects the new program to save costs through the following:Avoid lost profits from lost sales due to disappointed customers ....... Avoid rework and spoilage ................................................................. .. Avoid inspection of raw materials ........................................................ . Avoid…arrow_forward
- PLEASE 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_forwardIn an effort to raise the demand for reading tests, managers are planning to lower the price from $36 per test to $20 per test, the current price of the math test. They believe that doing so will increase the demand for reading tests to 60,000. Prepare a contribution format income statement reflecting Abado’s new pricing and demand structure. Abado Profiles provides testing services to school districts that wish to assess students’ reading and mathematical abilities. Last year Abado evaluated 60,000 math tests and 20,000 reading tests. An income statement for last year follows. Math Testing Reading Testing Total Per Unit Total Per Unit Total Company Sales revenue $1,200,000 $20 $720,000 $36 $1,920,000 Variable expenses 840,000 14 360,000 18 1,200,000 Contribution margin $360,000 $6 $360,000 $18 720,000 Fixed expenses 360,000 Operating income $360,000arrow_forwardYour company has received an order for 20 units of aproduct. Th e labor cost to produce the item is $9.50 per hour. Th esetup cost for the item is $60 and material costs are $25 per unit. Th e item is sold for $92. Th e learning rate is 80 percent. Overheadis assessed at a rate of 55 percent of unit labor cost.(a) Determine the average unit cost for the 20 units if the fi rstunit takes four hours.(b) Determine the minimum number of units that need to bemade before the selling price meets or exceeds the averageunit cost.arrow_forward
- John’s Publishing Company, a new service that writes term papers for college students, provides 11-page term papers from a list of more than 500 topics. Each paper will cost $7.50 and is written by a graduate in the topic area. John’s will pay $20,000 for the rights to all of the manuscripts. In addition, each author will receive $0.50 in royalties for every paper sold. Marketing expenses are estimated to be a total of $20,000 divided equally between Years 1 and 2, and John’s cost of capital is 11 percent. Sales are expected as follows: a. What are the ethical implications of this investment?arrow_forwardPlease review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.You are required to submit this assignment to LopesWrite. Please refer to the directions in the Student Success Center.Paul Duncan, financial manager of EduSoft Inc., is facing a dilemma. The firm was founded 5 years ago to provide educational software for the rapidly expanding primary and secondary school markets. Although EduSoft has done well, the firm's founder believes an industry shakeout is imminent. To survive, EduSoft must grab market share now, and this will require a large infusion of new capital.Because he expects earnings to continue rising sharply and looks for the stock price to follow suit, Mr. Duncan does not think it would be wise to issue new common stock at this time. On the other hand, interest rates are currently high by historical standards, and the firm's B rating means that interest payments on a new debt issue would be prohibitive.…arrow_forwardCompany manufactures and sells soccer balls for teams of children in elementary and high school. 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, expects to sell the following: Practice Balls Match Balls Units Selling Price Units Selling Price January 50,000 $8.25 6,000 $16.00 February 58,000 $8.25 8,000 $16.00 March 80,000 $8.25 14,000 $16.00 April 100,000 $8.25 18,000 $16.00 added a third line—tournament quality soccer that were expected to take 40 percent of the units sold of the match balls and would have a selling price of $45 each in January and February, and $48 each in March? Prepare a sales budget for FlashKick 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…arrow_forward
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning