Mona Pet Supplies' marketing manager and production manager have determined the sales forecast and the required production of their LED dog collars for the next six months. Budgeted production requirements of dog collars in units is as follows: May 70,000 June 72,000 July 80,000 August 85,000 September 82,000 October 78,000 Each dog collar requires 4 LED lights. Each LED light costs $0.15 and the supplier has been a little unpredictable; consequently, the company wants to have on hand at the end of each month 50% of the following month's production needs. Required: 1. Prepare a direct materials budget for LED lights for the 3rd quarter of the calendar year. List total quantity for each month and the total for the quarter. 2. What is Mona Pet Supplies' estimated cost for LED lights in July and August?

Mona Pet Supplies' marketing manager and production manager have determined the sales forecast and the required production of their LED dog collars for the next six months. Budgeted production requirements of dog collars in units is as follows: May 70,000 June 72,000 July 80,000 August 85,000 September 82,000 October 78,000 Each dog collar requires 4 LED lights. Each LED light costs $0.15 and the supplier has been a little unpredictable; consequently, the company wants to have on hand at the end of each month 50% of the following month's production needs. Required: 1. Prepare a direct materials budget for LED lights for the 3rd quarter of the calendar year. List total quantity for each month and the total for the quarter. 2. What is Mona Pet Supplies' estimated cost for LED lights in July and August?

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter13: Lean Manufacturing And Activity Analysis

Section: Chapter Questions

Problem 3BE

See similar textbooks

Similar questions

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?
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.
Nozama.com Inc. sells consumer electronics over the Internet. For the next period, the budgeted cost of the sales order processing activity is 250,000 and 50,000 sales orders are estimated to be processed. a. Determine the activity rate of the sales order processing activity. b. Determine the amount of sales order processing cost associated with 30,000 sales orders.
Lens & Shades sells sunglasses for $37 each and is estimating sales of 21,000 units in January and 19,000 in February. Each lens consist of 2.00 mm of plastic costing $2.50 per mm, 1.7 oz of dye costing $2.80 per ounce. and 0.50 hours direct labor at a labor rate of $18 per unit. Desired inventory levels are: Prepare a sales budget, production budget, direct materials budget for silicon and solution, and a direct labor budget.
TIB makes custom guitars and prepared the following sales budget for the second quarter It also has this additional information related to its expenses: Direct material per unit $55, Direct labor per hour 20, Variable manufacturing overhead per hour 3.50, Fixed manufacturing overhead per month 3,000, Sales commissions per unit 20, Sales salaries per month 5,000, Delivery expense per unit 0.50, Utilities per month 4,000. Administrative salaries per month 20,000, Marketing expenses per month 8,000, Insurance expense per month 11,000, Depreciation expense per month 9,000. Prepare a sales and administrative expense budget for each month in the quarter ended June 30. 2018.
Use the following information for Exercises 9-50 and 9-51: Assume that Stillwater Designs produces two automotive subwoofers: S12L7 and S12L5. The S12L7 sells for 475, and the S12L5 sells for 300. Projected sales (number of speakers) for the coming 5 quarters are as follows: The vice president of sales believes that the projected sales are realistic and can be achieved by the company. Exercise 9-50 Sales Budget Refer to the information regarding Stillwater Designs above. Required: 1. Prepare a sales budget for each quarter of 20X1 and for the year in total. Show sales by product and in total for each time period. 2. CONCEPTUAL CONNECTION How will Stillwater Designs use this sales budget?
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.
Lovely Wedding printing is budgeting sales of 32,000 units and already has 4,000 in beginning inventory. How many units must be produced to also meet the 6,000 units required in ending inventory?
The Silver Star Bicycle Company will manufacture both mens and womens models for its Easy-Pedal bicycles during the next two months. Management wants to develop a production schedule indicating how many bicycles of each model should be produced in each month. Current demand forecasts call for 150 mens and 125 womens models to be shipped during the first month and 200 mens and 150 womens models to be shipped during the second month. Additional data are as follows: Last month, the company used a total of 1,000 hours of labor. The companys labor relations policy will not allow the combined total hours of labor (manufacturing plus assembly) to increase or decrease by more than 100 hours from month to month. In addition, the company charges monthly inventory at the rate of 2% of the production cost based on the inventory levels at the end of the month. The company would like to have at least 25 units of each model in inventory at the end of the two months. (Hint: Define variables for production and inventory held in each period for each product. Then use a constraint to define the relationship between these: inventory from end of previous period + produced this period demand this period = inventory at end of this period.) a. Establish a production schedule that minimizes production and inventory costs and satisfies the labor-smoothing, demand, and inventory requirements. What inventories will be maintained and what are the monthly labor requirements? b. If the company changed the constraints so that monthly labor increases and decreases could not exceed 50 hours, what would happen to the production schedule? How much will the cost increase? What would you recommend?
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.
Krouse Company produces two products, forged putter heads and laminated putter heads, which are sold through specialty golf shops. The company is in the process of developing itsoperating budget for the coming year. Selected data regarding the companys two products areas follows: Manufacturing overhead is applied to units using direct labor hours. Variable manufacturing overhead Ls projected to be 25,000, and fixed manufacturing overhead is expected to be15,000. The estimated cost to produce one unit of the laminated putter head is: a. 42. b. 46. c. 52. d. 62.
Aspen Enterprises makes award pins for various events. Budget information regarding the current period is: A fraternity with which Aspen has a long relationship approached Aspen with a special order for 6,000 pins at a price of $2.75 per pin. Variable costs will be the same as the current production, and the special order will not impact the rest of the companys orders. However, Aspen is operating at capacity and will incur an additional $5,000 in fixed manufacturing overhead if the order is accepted. Based on this information, what is the differential income (loss) associated with accepting the special order?