Please do not give solution in image format thanku During the first quarter, ended March 31, 2022, 1.220 units were actually produced with the following costs.Polyethylene powderFinishing kitsType 1 labourType 11 labourIndirect materialsManufacturing suppliesMaintenance and utilitiesSupervisionInsuranceDepreciationTotalUnits to be ProducedVariable CostsPolyethylene PowderFinishing KitsPrepare the flexible budget for manufacturing for the quarter ended March 31, 2022. Assume activity levels of 1,070, 1,170, and1,220 units. (List variable costs before fixed costs)Labour-Type 1Labour-TypeIndirect MaterialsManufacturing SuppliesMaintenance and UtilitiesTotal Variable CostsFixed CostsSupervisionInsuranceDepreciationTotal Food CostsTotal CostsV$97.030219.90024,400V26,81013.42018,33730.52015,5003,00027.800$476,717CURRENT DESIGNSRotomoulded LineFlexible Manufacturing BudgetFor the Quarter Ending March 31, 2022107011701220 Current Attempt in ProgressThe Current Designs staff has prepared the annual manufacturing budget for the rotomoulded line based on an estimated annualproduction of 4,680 kayaks during 2022. Each kayak will require 78 kilograms of polyethylene powder and a finishing kit (rope, seat,hardware, etc.). The polyethylene powder used in these kayaks costs $1.00 per kilogram, and the finishing kits cost $180 each. Eachkayak will use two kinds of labour-2 hours of type I labour from people who run the oven and trim the plastic, and 3 hours of workfrom type Il workers who attach the hatches and seat and other hardware. The type I employees are paid $10 per hour, and the type IIemployees are paid $7 per hour.Manufacturing overhead is budgeted at $426,520 for 2022, broken down as follows.Variable costsIndirect materialsManufacturing suppliesMaintenance and utilitiesFixed costsSupervisionInsuranceDepreciationTotal$51,48070,200107,640229,32074,00012,000111,200197.200$426,520During the first quarter, ended March 31, 2022. 1.220 units were actually produced with the following costs.

A flexible budget is prepared apart from a fixed budget. It shows the budgeted value at different…

The Current Designs staff has prepared the annual manufacturing budget for the rotomoulded line based on an estimated annual production of 4,680 kayaks during 2022. Each kayak will require 78 kilograms of polyethylene powder and a finishing kit (rope, seat, hardware, etc.). The polyethylene powder used in these kayaks costs $1.00 per kilogram, and the finishing kits cost $180 each. Each kayak will use two kinds of labour-2 hours of type I labour from people who run the oven and trim the plastic, and 3 hours of work from type Il workers who attach the hatches and seat and other hardware. The type I employees are paid $10 per hour, and the type employees are paid $7 per hour. Manufacturing overhead is budgeted at $426,520 for 2022, broken down as follows. Variable costs Indirect materials Manufacturing supplies Maintenance and utilities Fixed costs Supervision Insurance Depreciation Total $51,480 70,200 107,640 229,320 74,000 12,000 111,200 197.200 $426,520 During the first quarter, ended March 31, 2022, 1.220 units were actually produced with the following costs.

The Current Designs staff has prepared the annual manufacturing budget for the rotomoulded line based on an estimated annual production of 4,680 kayaks during 2022. Each kayak will require 78 kilograms of polyethylene powder and a finishing kit (rope, seat, hardware, etc.). The polyethylene powder used in these kayaks costs $1.00 per kilogram, and the finishing kits cost $180 each. Each kayak will use two kinds of labour-2 hours of type I labour from people who run the oven and trim the plastic, and 3 hours of work from type Il workers who attach the hatches and seat and other hardware. The type I employees are paid $10 per hour, and the type employees are paid $7 per hour. Manufacturing overhead is budgeted at $426,520 for 2022, broken down as follows. Variable costs Indirect materials Manufacturing supplies Maintenance and utilities Fixed costs Supervision Insurance Depreciation Total $51,480 70,200 107,640 229,320 74,000 12,000 111,200 197.200 $426,520 During the first quarter, ended March 31, 2022, 1.220 units were actually produced with the following costs.

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.
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.
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?
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.
Refer to Cornerstone Exercises 2.2 and 2.3. Next year, Pietro expects to produce 50,000 units and sell 49,300 units at a price of 12.50 each. Beginning inventory of finished goods is 42,500, and ending inventory of finished goods is expected to be 34,000. Total selling expense is projected at 26,000, and total administrative expense is projected at 134,000. Required: 1. Prepare an income statement in good form. Be sure to include the percent of sales column. 2. What if the cost of goods sold percentage for the past few years was 65 percent? Explain how management might react.
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.
CASH BUDGETING Helen Bowers, owner of Helens Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2019 and 2020: Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale, 75%; collected the second month following the sale, 15%. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus raw materials: General and administrative salaries are approximately 27,000 a month. Lease payments under long-term leases are 9,000 a month. Depreciation charges are 36,000 a month. Miscellaneous expenses are 2,700 a month. Income tax payments of 63,000 are due in September and December. A progress payment of 180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be 132,000, and a minimum cash balance of 90,000 should be maintained throughout the cash budget period. a. Prepare a monthly cash budget for the last 6 months of 2019. b. Prepare monthly estimates of the required financing or excess fundsthat is, the amount of money Bowers will need to borrow or will have available to invest. c. Now suppose receipts from sales come in uniformly during the month (that is, cash receipts come in at the rate of 1/30 each day), but all outflows must be paid on the 5th. Will this affect the cash budget? That is, will the cash budget you prepared be valid under these assumptions? If not, what could be done to make a valid estimate of the peak financing requirements? No calculations are required, although if you prefer, you can use calculations to illustrate the effects. d. Bowers sales are seasonal, and her company produces on a seasonal basis, just ahead of sales. Without making any calculations, discuss how the companys current and debt ratios would vary during the year if all financial requirements were met with short-term bank loans. Could changes in these ratios affect the firms ability to obtain bank credit? Explain.
One Device makes universal remote controls and expects to sell 500 units in January, 800 in February, 450 in March, 550 in April, and 600 in May. The required ending inventory is 20% of the next months sales. Prepare a production budget for the first four months of the year.
Foy Company has a welding activity and wants to develop a flexible budget formula for the activity. The following resources are used by the activity: Four welding units, with a lease cost of 12,000 per year per unit Six welding employees each paid a salary of 50,000 per year (A total of 9,000 welding hours are supplied by the six workers.) Welding supplies: 300 per job Welding hours: Three hours used per job During the year, the activity operated at 90 percent of capacity and incurred the actual activity and resource costs, shown on page 676. Lease cost: 48,000 Salaries: 315,000 Parts and supplies: 805,000 Required: 1. Prepare a flexible budget formula for the welding activity using welding hours as the driver. 2. Prepare a performance report for the welding activity. 3. What if welders were hired through outsourcing and paid 30 per hour (the welding equipment is provided by Foy)? Repeat Requirement 1 for the outsourcing case.
Cash budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent 50,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. Current assets as of September 1 include cash of 40,000, marketable securities of 75,000, and accounts receivable of 300,000 (60,000 from July sales and 240,000 from August sales). Sales on account for July and August were 200,000 and 240,000, respectively. Current liabilities as of September 1 include 40,000 of accounts payable incurred in August for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of 55,000 will be made in October. Bridgeports regular quarterly dividend of 25,000 is expected to be declared in October and paid in November. Management desires to maintain a minimum cash balance of 50,000. Instructions Prepare a monthly cash budget and supporting schedules for September, October, and November. On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?
The Current Designs staff has prepared the annual manufacturing budget for the rotomolded line based on an estimated annual production of 3,440 kayaks during 2020. Each kayak will require 54 pounds of polyethylene powder and a finishing kit (rope, seat, hardware, etc.). The polyethylene powder used in these kayaks costs $1.10 per pound, and the finishing kits cost $250 each. Each kayak will use two kinds of labor—2 hours of type I labor from people who run the oven and trim the plastic, and 3 hours of work from type II workers who attach the hatches and seat and other hardware. The type I employees are paid $14 per hour, and the type II are paid $11 per hour.Manufacturing overhead is budgeted at $390,400 for 2020, broken down as follows. Variable costs Indirect materials $41,280 Manufacturing supplies 44,720 Maintenance and utilities 86,000 172,000 Fixed costs Supervision 96,000 Insurance 14,400 Depreciation 108,000…
The budgeted distribution costs for next year comprise transport costs of £568,000and customer order processing costs of £29,050. It is estimated that in the next year,8,300 orders will be processed and that the delivery vehicles will travel 400,000kilometres.One of the company’s customers has indicated that it will place 50 orders in the nextyear, each of which will involve a journey of 130 kilometres by delivery vehicle.What is the distribution cost for this customer? Show all workings