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?

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

NuFloor Manufacturing produces floor tiles. The managers at NuFloor are trying to develop budgets for the upcoming quarter. The following data have been gathered for a particular tile design. Projected unit sales 3,600 cases Selling price per case $ 200 Inventory at the beginning of the quarter 600 cases Target inventory at the end of the quarter 800 cases Direct labor hours needed to produce one case 0.40 hours Direct labor wages $ 15 per hour Direct material cost per case $ 16 Variable manufacturing overhead cost per case $ 10 Fixed overhead costs for the upcoming quarter $ 319,200
Classic Loungers is in the process of preparing a production cost budget for August. Actual costs in July for 400 chaise lounge chairs were: Materials cost $ 6,000 Labor cost 8,000 Rent 2,000 Depreciation 4,000 Other fixed costs 5,000 Total $ 25,000 Material cost and Labor cost are considered variable. Each chair was sold for $160 in July. Management estimates that sales will increase to 440 chairs during August if the company lowers the selling price to $150 per chair. What is the incremental profit (loss) associated with the price reduction? $(200) $(2,200) $2,100 $800 $600
Minty Madness Co. manufactures mint-flavoured products. Minty has four main products: Minty Cookies, Minty Ice Cream, Minty Chocolate, and Minty Gum. Maximum demand for these products is 20 units of each per month. Each product requires a different amount of mint. Since Minty only uses a specially flavoured mint in its products, it is limited to 100 kgs of mint each month. Management is reviewing its budget for the month of March, and has provided the following data: Cookies $60 $25 1.5 kg Ice Cream $90 $48 2 kg Chocolate $50 $26 0.75 kg Gum Sales price per unit Variable costs per unit Mint required per unit $40 $18 1.25 kg Required: Analyze this data and determine the best product mix for Minty Madness Co. to maximize its profitability in the month of March. Ensure that you show all your calculations.
Hansaben
Dog
Symphony Electronics produces wireless speakers for outdoor use on patios, decks, etc. Their most popular model is the All Weather and requires four separate XL12 components per unit. The company is now planning raw material needs for the second quarter. Sales of the All Weather are the highest in the second quarter of each year as customers prepare for the summer season. The company has the following inventory requirements: a. The finished goods inventory on hand at the end of each month must be equal to 16,300 units plus 10% of the next month's sales. The finished goods inventory on March 31 is budgeted to be 28,000 units. b. The raw materials inventory on hand at the end of each month must be equal to 20% of the following month's production needs for raw materials. The raw materials inventory on March 31 for XL 12 is budgeted to be 98,500 components. c. The company maintains no work in process inventories. A sales budget for the All Weather speaker is as follows: April May June July…
Black Diamond Company produces snow skis. Each ski requires 3 pounds of carbon fiber. The company’s management predicts that 5,500 skis and 6,500 pounds of carbon fiber will be in inventory on June 30 of the current year and that 155,000 skis will be sold during the next (third) quarter. A set of two skis sells for $350. Management wants to end the third quarter with 4,000 skis and 4,500 pounds of carbon fiber in inventory. Carbon fiber can be purchased for $20 per pound. Each ski requires 0.4 hours of direct labor at $25 per hour. Variable overhead is applied at the rate of $13 per direct labor hour. The company budgets fixed overhead of $1,787,000 for the quarter. Prepare the third-quarter direct materials (carbon fiber) budget; include the dollar cost of purchases. BLACK DIAMOND COMPANY Direct Materials Budget Third Quarter Budgeted production Materials needed for production (lbs.) Total materials requirements (lbs.)…
Required information [The following information applies to the questions displayed below.] Black Diamond Company produces snowboards. Each snowboard requires 2 pounds of carbon fiber. Management reports that 6,400 snowboards and 7,400 pounds of carbon fiber are in inventory at the beginning of the third quarter, and that 164,000 snowboards are budgeted to be sold during the third quarter. Management wants to end the third quarter with 4,900 snowboards and 5,400 pounds of carbon fiber in inventory. Carbon fiber costs $13 per pound. Each snowboard requires 0.5 hour of direct labor at $18 per hour. Variable overhead is budgeted at the rate of $8 per direct labor hour. The company budgets fixed overhead of $1,796,000 for the quarter. 4. Prepare the factory overhead budget for the third quarter. BLACK DIAMOND COMPANY Factory Overhead Budget Third Quarter Direct labor hours needed Budgeted variable overhead Budgeted total factory overhead
Black Diamond Company produces snow skis. Each ski requires 3 pounds of carbon fiber. The company’s management predicts that 5,500 skis and 6,500 pounds of carbon fiber will be in inventory on June 30 of the current year and that 155,000 skis will be sold during the next (third) quarter. A set of two skis sells for $350. Management wants to end the third quarter with 4,000 skis and 4,500 pounds of carbon fiber in inventory. Carbon fiber can be purchased for $20 per pound. Each ski requires 0.4 hours of direct labor at $25 per hour. Variable overhead is applied at the rate of $13 per direct labor hour. The company budgets fixed overhead of $1,787,000 for the quarter. Prepare the third-quarter production budget for skis. BLACK DIAMOND COMPANY Production Budget (in units) Third Quarter Required units of available production Units to be manufactured
Alyeski Tours operates day tours of coastal glaciers in Alaska on its tour boat the Blue Glacier. Management has identified two cost drivers—the number of cruises and the number of passengers—that it uses in its budgeting and performance reports. The company publishes a schedule of day cruises that it may supplement with special sailings if there is sufficient demand. Up to 88 passengers can be accommodated on the tour boat. Data concerning the company’s cost formulas appear below: Fixed Cost per Month Cost per Cruise Cost per Passenger Vessel operating costs $ 6,400 $ 478.00 $ 3.20 Advertising $ 2,600 Administrative costs $ 5,000 $ 32.00 $ 1.50 Insurance $ 3,300 For example, vessel operating costs should be $6,400 per month plus $478.00 per cruise plus $3.20 per passenger. The company’s sales should average $35.00 per passenger. In July, the company provided 51 cruises for a total of 3,000 passengers. Required: Prepare the company’s flexible budget for…
Required information [The following information applies to the questions displayed below.] Black Diamond Company produces snowboards. Each snowboard requires 2 pounds of carbon fiber. Management reports that 6,900 snowboards and 7,900 pounds of carbon fiber are in inventory at the beginning of the third quarter, and that 169,000 snowboards are budgeted to be sold during the third quarter. Management wants to end the third quarter with 5,400 snowboards and 5,900 pounds of carbon fiber in inventory. Carbon fiber costs $18 per pound. Each snowboard requires 0.5 hour of direct labor at $23 per hour. Variable overhead is budgeted at the rate of $13 per direct labor hour. The company budgets fixed overhead of $1,801,000 for the quarter. 2. Prepare the direct materials budget for the third quarter. BLACK DIAMOND COMPANY Direct Materials Budget Units to produce Budgeted units sales for month Materials needed for production (pounds) Add: Desired ending materials inventory (pounds) Total…
ErgoNow sells its main product, ergonomic mouse pads, for $12 each. Its variable cost is $5.40 per pad. Fixed costs are $200,000 per month for volumes up to 65,000 pads. Above 65,000 pads, monthly fixed costs are $260,000. Prepare a monthly flexible budget for the product, showing sales revenue, variable costs, fixed costs, and operating income for volume levels of 35,000, 45,000, and 75,000 pads. ErgoNow Flexible Budget Budget Amounts Per Unit Units 35,000 45,000 75,000 (1) (2) (3) (4) (5) (1) Contribution Margin Fixed Costs Operating Income Sales Revenue Variable Costs (2) Contribution Margin Fixed Costs Operating Income Sales Revenue Variable Costs (3)…