Cash is running low, and Patience is working against the clock to purchase DM for the final month's production push. Each unit requires 7 pounds of material, with each pound costing $0.40. The company's target ending inventory for DM is 20% of the next month's production needs, and it expects to hold just that amount of inventory on November 30. Planned production in December and January is expected to be 1,000 units and 1,200 units, respectively. Prepare the DM purchases budget for December, determining both the quantity to be purchased and the total cost of purchases for the company. (Round DM cost per unit to 2 decimal places, e.g. 15.25.) December

Cash is running low, and Patience is working against the clock to purchase DM for the final month's production push. Each unit requires 7 pounds of material, with each pound costing $0.40. The company's target ending inventory for DM is 20% of the next month's production needs, and it expects to hold just that amount of inventory on November 30. Planned production in December and January is expected to be 1,000 units and 1,200 units, respectively. Prepare the DM purchases budget for December, determining both the quantity to be purchased and the total cost of purchases for the company. (Round DM cost per unit to 2 decimal places, e.g. 15.25.) December

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter7: Budgeting

Section: Chapter Questions

Problem 1PA: Lens Junction sells lenses for $45 each and is estimating sales of 15,000 units in January and...

See similar textbooks

Similar questions

Play-Disc makes Frisbee-type plastic discs. Each 12-inch diameter plastic disc has the following manufacturing costs: For the coming year, Play-Disc expects to make 300,000 plastic discs, and to sell 285,000 of them. Budgeted beginning inventory in units is 16,000 with unit cost of 4.75. (There are no beginning or ending inventories of work in process.) Required: 1. Prepare an ending finished goods inventory budget for Play-Disc for the coming year. 2. What if sales increased to 290,000 discs? How would that affect the ending finished goods inventory budget? Calculate the value of budgeted ending finished goods inventory.
Sunrise Poles manufactures hiking poles and is planning on producing 4,000 units in March and 3,700 in April. Each pole requires a half pound of material, which costs $1.20 per pound. The companys policy is to have enough material on hand to equal 10% of the next months production needs and to maintain a finished goods inventory equal to 25% of the next months production needs. What is the budgeted cost of purchases for March?
Cloud Shoes manufactures recovery sandals and is planning on producing 12.000 units in March and 11,500 in April. Each sandal requires 1.2 yards if material, which costs $3.00 per yard. The companys policy is to have enough material on hand to equal 15% of next months production needs and to maintain a finished goods inventory equal to 20% of the next months production needs. What is the budgeted cost of purchases for March?
Lowell Manufacturing Inc. has a normal selling price of 20 per unit and has been selling 125,000 units per month. In November, Lowell Manufacturing decided to lower its price to 19 per unit expecting it can increase the units sold by 16%. a. Compute the normal revenue with a 20 selling price. b. Compute the planned revenue with a 19 selling price. c. Compute the actual revenue for November, assuming 135,000 units were sold in November at 19 per unit. d. Compute the revenue price variance, assuming 135,000 units were sold in November at 19 per unit. e. Compute the revenue volume variance, assuming 135,000 units were sold in November at 19 per unit. f. Analyze and interpret the lowering of the price to 19.
Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the follow sales: In Shalimars experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are 4,900,000 and for the fourth quarter of the current year are 6,850,000. Required: 1. Calculate cash sales and credit sales expected in the last two quarters of the current year, and in each quarter of next year. 2. Construct a cash receipts budget for Shalimar Company for each quarter of the next year, showing the cash sales and the cash collections from credit sales. 3. What if the recession led Shalimars top management to assume that in the next year 10 percent of credit sales would never be collected? The expected payment percentages in the quarter of sale and the quarter after sale are assumed to be the same. How would that affect cash received in each quarter? Construct a revised cash budget using the new assumption.
Rehydrator makes a nutrition additive and expects to sell 3,000 units in January, 2,000 in February, 2,500 in March, 2,700 in April. and 2,900 in May. The required ending inventory is 20% of the next months sales, and the beginning inventory on January 1 was 600 units. Prepare a production budget for the first four months of the year.
Crescent Company produces stuffed toy animals; one of these is Arabeau the Cow. Each Arabeau takes 0.20 yard of fabric (white with irregular black splotches) and eight ounces of polyfiberfill. Fabric costs 3.50 per yard and polyfiberfill is 0.05 per ounce. Crescent has budgeted production of Arabeaus for the next four months as follows: Inventory policy requires that sufficient fabric be in ending monthly inventory to satisfy 20 percent of the following months production needs and sufficient polyfiberfill be in inventory to satisfy 40 percent of the following months production needs. Inventory of fabric and polyfiberfill at the beginning of October equals exactly the amount needed to satisfy the inventory policy. Each Arabeau produced requires (on average) 0.10 direct labor hour. The average cost of direct labor is 15 per hour. Required: 1. Prepare a direct materials purchases budget of fabric for the last quarter of the year showing purchases in units and in dollars for each month and for the quarter in total. 2. Prepare a direct materials purchases budget of polyfiberfill for the last quarter of the year showing purchases in units and in dollars for each month and for the quarter in total. 3. Prepare a direct labor budget for the last quarter of the year showing the hours needed and the direct labor cost for each month and for the quarter in total.
Lens Junction sells lenses for $45 each and is estimating sales of 15,000 units in January and 18,000 in February. Each lens consists of 2 pounds of silicon costing $2.50 per pound, 3 oz of solution costing $3 per ounce, and 30 minutes of direct labor at a labor rate of $18 per hour. Desired inventory levels are: Â Prepare a sales budget, production budget. direct materials budget for silicon and solution, and a direct labor budget.
The sales department of Macro Manufacturing Co. has forecast sales for its single product to be 20,000 units for June, with three-quarters of the sales expected in the East region and one-fourth in the West region. The budgeted selling price is 25 per unit. The desired ending inventory on June 30 is 2,000 units, and the expected beginning inventory on June 1 is 3,000 units. Prepare the following: a. A sales budget for June. b. A production budget for June.
If the sales forecast estimates that 50,000 units of product will be sold during the following year, should the factory plan on manufacturing 50,000 units in the coming year? Explain.
Nico Parts, Inc., produces electronic products with short life cycles (of less than two years). Development has to be rapid, and the profitability of the products is tied strongly to the ability to find designs that will keep production and logistics costs low. Recently, management has also decided that post-purchase costs are important in design decisions. Last month, a proposal for a new product was presented to management. The total market was projected at 200,000 units (for the two-year period). The proposed selling price was 130 per unit. At this price, market share was expected to be 25 percent. The manufacturing and logistics costs were estimated to be 120 per unit. Upon reviewing the projected figures, Brian Metcalf, president of Nico, called in his chief design engineer, Mark Williams, and his marketing manager, Cathy McCourt. The following conversation was recorded: BRIAN: Mark, as you know, we agreed that a profit of 15 per unit is needed for this new product. Also, as I look at the projected market share, 25 percent isnt acceptable. Total profits need to be increased. Cathy, what suggestions do you have? CATHY: Simple. Decrease the selling price to 125 and we expand our market share to 35 percent. To increase total profits, however, we need some cost reductions as well. BRIAN: Youre right. However, keep in mind that I do not want to earn a profit that is less than 15 per unit. MARK: Does that 15 per unit factor in preproduction costs? You know we have already spent 100,000 on developing this product. To lower costs will require more expenditure on development. BRIAN: Good point. No, the projected cost of 120 does not include the 100,000 we have already spent. I do want a design that will provide a 15-per-unit profit, including consideration of preproduction costs. CATHY: I might mention that post-purchase costs are important as well. The current design will impose about 10 per unit for using, maintaining, and disposing our product. Thats about the same as our competitors. If we can reduce that cost to about 5 per unit by designing a better product, we could probably capture about 50 percent of the market. I have just completed a marketing survey at Marks request and have found out that the current design has two features not valued by potential customers. These two features have a projected cost of 6 per unit. However, the price consumers are willing to pay for the product is the same with or without the features. Required: 1. Calculate the target cost associated with the initial 25 percent market share. Does the initial design meet this target? Now calculate the total life-cycle profit that the current (initial) design offers (including preproduction costs). 2. Assume that the two features that are apparently not valued by consumers will be eliminated. Also assume that the selling price is lowered to 125. a. Calculate the target cost for the 125 price and 35 percent market share. b. How much more cost reduction is needed? c. What are the total life-cycle profits now projected for the new product? d. Describe the three general approaches that Nico can take to reduce the projected cost to this new target. Of the three approaches, which is likely to produce the most reduction? 3. Suppose that the Engineering Department has two new designs: Design A and Design B. Both designs eliminate the two nonvalued features. Both designs also reduce production and logistics costs by an additional 8 per unit. Design A, however, leaves post-purchase costs at 10 per unit, while Design B reduces post-purchase costs to 4 per unit. Developing and testing Design A costs an additional 150,000, while Design B costs an additional 300,000. Assuming a price of 125, calculate the total life-cycle profits under each design. Which would you choose? Explain. What if the design you chose cost an additional 500,000 instead of 150,000 or 300,000? Would this have changed your decision? 4. Refer to Requirement 3. For every extra dollar spent on preproduction activities, how much benefit was generated? What does this say about the importance of knowing the linkages between preproduction activities and later activities?
Cadre, Inc., sells a single product with a selling price of $120 and variable costs per unit of $90. The companys monthly fixed expenses are $180,000. What is the companys break-even point in units? What is the companys break-even point in dollars? Prepare a contribution margin income statement for the month of October when they will sell 10,000 units. How many units will Cadre need to sell in order to realize a target profit of $300,000? What dollar sales will Cadre need to generate in order to realize a target profit of $300,000? Construct a contribution margin income statement for the month of August that reflects $2,400,000 in sales revenue for Cadre, Inc.