**Lugo Company Sales and Production Budgets for April, May, and June****Overview:**Lugo Company manufactures drinking glasses. Each unit is a package of eight glasses, selling for $24. Expected sales for April are projected at 2,500 packages, increasing by 200 packages in each subsequent month, May and June, continuing into July. As of April 1, Lugo has 400 packages in inventory and aims to maintain an ending inventory of 20% of the following month's sales. Below is a detailed breakdown of the sales and production budgets for each month.**Sales Budget:**| | April | May | June | Total ||------------------------|-------|-----|------|--------|| Budgeted packages to be sold | 2,500 | 2,700 | 2,900 | 8,100 || Sales price per package | $24 | $24 | $24 | $24 || Total sales | $60,000 | $64,800 | $69,600 | $194,400 |*This section of the budget outlines the number of packages expected to be sold and the total sales revenue for each month.***Production Budget:**| | April | May | June | Total ||------------------------|-------|-----|------|--------|| Budgeted packages to be sold | 2,500 | 2,700 | 2,900 | 8,100 || Plus: Desired packages in ending inventory | | | | || Total packages needed | | | | || Less: Packages in beginning inventory | | | | || Budgeted packages to be produced | | | | |*The production budget is intended to calculate the number of packages that need to be produced, considering the desired ending inventory and the packages already available at the start of each month.***Key Steps in Budget Preparation:**1. **Determine Sales Projections:** Estimate the number of packages to be sold each month.2. **Calculate Revenue:** Multiply the expected sales volume by the price per package.3. **Inventory Planning:** Ensure that the company maintains an ending inventory of 20% of the following month's sales.4. **Production Scheduling:** Compute the total production requirement by considering the sales forecast and inventory needs.The budget preparation assists Lugo Company in aligning

Production budget:- Production budget is the budget that is prepared by production companies for knowing how many units are to be produced for a day/week/month/quarter/half year/year so that there will be no loss. Production budget of Lugo company April May June Total Budgeted packages to be sold 2500 2700 2900 8100 (+) Desired packages in the ending 540 580 620 1740 inventory (20% of next month's BP to be sold) Total packages needed 3040 3280 3520 9840 (-) Packages in the beginning inventory 400 540 580 1520 Budgeted packages to be produced 2640 2740 2940 8320

Business

Accounting

Now prepare a production budget for April, May, and June. Lugo Company Production Budget April, May, and June April May June Total 2500 2700 2900 8100 Budgeted packages to be sold Plus: Desired packages in ending inventory Total packages needed Less: Packages in beginning inventory Budgeted packages to be produced

Now prepare a production budget for April, May, and June. Lugo Company Production Budget April, May, and June April May June Total 2500 2700 2900 8100 Budgeted packages to be sold Plus: Desired packages in ending inventory Total packages needed Less: Packages in beginning inventory Budgeted packages to be produced

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

Please help me with show all calculation thanku
this is actually a budgeting lesson. Beginning inventory 4.000 unit Ending inventory 3.500 unit The lack will be allocated to the 5 months (Jan, Feb, March, April dan May). Arrange production budget with a policy that accentuate production stability!
please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste
How do I prepare the selling and administrative expense budget for the quarter ended March 31, 20X1?
Function: SUM; Formula: Subtract, Multiply; Cell Referencing Using Excel to Prepare a Production Budget PROBLEM Paige Company estimates that following unit sales and desired inventory level for the four quarters of the year ending December 31, 2022. Quarter 1 sales Quarter 2 sales Quarter 3 sales Quarter 4 sales Desired ending finished goods inventory based on next quarter's expected unit sales Unit selling price 10,000 14,000 15,000 18,000 25% $ 70.00 Prepare a production budget by quarters for the first 6 months of 2022. Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area or this work area as indicated. Use the SUM function with cell referencing for totals. Paige Company Production Budget For the Six Months Ending June 30, 2022 Quarter 1 10,000 Expected unit sales Add: Desired ending finished goods units Total required units Less: Beginning finished goods units Required production…
dont provide handwriing solution...
Mallory Company expects to sell 130 units in the first quarter, and 70 units in the second quarter. Assuming the company prefers to maintain finished goods inventory equal to 40% of the next quarter's sales, prepare a production budget for the first quarter only. Hint: This quarter's projected sales were used to determine last quarter's required ending inventory. Mallory Company Production Budget First Quarter Budgeted Sales in units Add: desired ending finished goods inventory Total finished goods inventory needed Deduct: beginning finished goods inventory Units to be produced 1st Qtr.
Please do not give solution in image format thanku
Please do not give solution in image format thanku
Vibrant Inc. manufactures two models of speakers, Rumble and Thunder. Based on the following production and sales data for June, prepare (a) a sales budget and (b) a production budget: Rumble Thunder Estimated inventory (units), June 1 Desired inventory 250 75 287 65 (units), June 30 Expected sales volume (units): North Region 2,400 2,100 South Region 5,800 6,550 Unit sales price $125 $225 a. Prepare a sales budget. Vibrant Inc. Sales Budget For the Month Ending June 30 Unit Sales Selling Volume Price Unit Total Sales Product and Area Model Rumble: North Region South Region Total Model Thunder: North Region South Region Total Total revenue from sales
Please avoid handwritten solution thanku
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,400 units plus 10% of the next month's sales. The finished goods inventory on March 31 is budgeted to be 28,700 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,800 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…