Patrick Inc. sells industrial solvents in 5-gallon drums. Patrick expects the following units to be sold in the first 3 months of the coming year: January February 41,000 38,000 March 50,000 The average price for a drum is $35. Required: Prepare a sales budget for the first 3 months of the coming year, showing units and sales revenue by month and in total for the quarter.
Q: Big Sound, a merchandising company specializing in home computer speakers, budgets its monthly cost…
A: Budgeting: It is a process of planning the work to be performed. Under this process a formal plan is…
Q: Lugo Company manufactures drinking glasses. One unit is a package of eight glasses, which sells for…
A: The sales budget is based on units expected to be sold and the sale price. This budget is prepared…
Q: Jackson Inc. produces leather handbags. The production budget for the next four months is: July…
A: Formulas: Expected units of leather = Material cost + Closing inventory - Opening inventory
Q: Silver Company makes a product that is very popular as a Mother’s Day gift. Thus, peak sales occur…
A: 1. Schedule of Expected Cash Collections April May June Total February sales ($320,000 x…
Q: Hurtt’s Java Seeds is an independent roaster of specialty coffee beans. The company budgets 2 months…
A: Standard Production Cost=Direct material+Direct labor+Variable Overhead+Fixed Overhead
Q: The company sells many styles of earrings, but all are sold for the same price - $10 per pair.…
A: Budgeting: It is a process of planning the work to be performed. Under this process a formal plan is…
Q: Knowledge Check 01 Well Wheats, Inc. produces breakfast cereal and sells each box, or unit, for $7.…
A: Since you have asked multiple questions, we will solve 1st question to you, if you want any specific…
Q: Gallonte Inc. began operations in April of this year. It makes all sales on account, subject to the…
A:
Q: Forrest Company manufactures phone chargers and has a policy that ending inventory should equal 20%…
A: Desired ending inventory = December sales x 20% = 370000 x 20% = 74000 units
Q: Rida, Inc., a manufacturer in a seasonal industry, is preparing its direct materials budget for the…
A: Definition: Direct material budget: The direct material budget shows how much raw material purchases…
Q: The company sells many styles of earrings, but all are sold for the same price - $10 per pair.…
A: Purchase budget is prepared to estimate the amount of inventory required in the firm. It is prepared…
Q: Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur…
A: Accounts receivable refers to money owing to a seller by buyers who have not yet paid for their…
Q: Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur…
A: Accounts receivable is the amount that is about to collect from the customers or the amount of goods…
Q: Mackinac Island produces various fudge flavors,the most popular being chocolate fudge. The…
A: Purchase = Requirement + Desired ending material inventory − Beginning inventory material inventory
Q: Ramos Co. provides the following sales forecast and production budget for the next four months.…
A: Budget:- A budget is considered as the estimation of revenue and expense over a specified period of…
Q: Gallonte Inc began operations in April of this year, it makes all sales on accountyubject to the…
A: Cost Accounting: It is the process of collecting, recording, analyzing the cost, summarizing cost,…
Q: Sunrise Poles manufactures hiking poles and is planning on producing 3,624 units in March and 2,954…
A: Particular April Budgeted production units (a) 2954 Pound materials per unit (b) 0.5 Estimated…
Q: Weltin Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data…
A: “Since you have posted a question with multiple sub-parts, we will solve first three sub-parts for…
Q: Springton makes and sells a single product, black handbags, at a price of $1,600 each. During the…
A: A budget is a forecast of revenue and expenses for a certain future period of time that is generally…
Q: Avalon Company makes a product that is very popular as a Mother’s Day gift, thus peak sales occur in…
A:
Q: ABC Ltd. makes and sells picture frames. A sales and production budget for the coming period…
A: Budgeting - Budgeting is the process of estimating future operations based on past performance. %…
Q: January (actual) 20,000 February (actual) 26,000 March (actual) 40,000 April (budget)…
A: Cash budget is a statement to used for a business over a period of time . This budget also…
Q: Ecology Company sells a biodegradable product called Run-All and has the following sales on account…
A: Cash Budget Cash Budget is refer as a budget which is prepared to estimate the cash inflow and…
Q: Prepare a sales budget for the first three months of the coming year, showing units and sales…
A: Sales budget: A sales budget is the expected sales which a manufacturing company is going to sell…
Q: Gallonte Inc. began operations in April of this year. It makes all sales on account, subject to the…
A: Cost Accounting: It is the process of collecting, recording, analyzing the cost, summarizing cost,…
Q: Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur…
A: Solution 1: Schedule of expected cash collection - Silver Company Particulars April May…
Q: Freese Inc. is in the process of preparing the fourth quarter budget for 2019, and the following…
A: Budgeting is a process of creating a financial plan for a coming year.
Q: Big Sound, a merchandising company specializing in home computer speakers, budgets its monthly cost…
A: (1)
Q: Lugo Company manufactures drinking glasses. One unit is a package of eight glasses, which sells for…
A: The production budget is used by the management to find out the units to be produced. It can be…
Q: Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur…
A: The accounts receivable balance on any month-end shall be the sales that haven't been collected in…
Q: Preston, Inc., manufactures wooden shelving units for collecting and sorting mail. The company…
A: Raw materials purchases budget tells us about the estimated amount that a company will spend on…
Q: Osborne Manufacturing produces self-watering planters for use in upscale retail establishments.…
A: Production Budget = Sales units + closing stock - openings stock
Q: Prepare a production budget for the first four months of the year.
A: Production budget: Production budget is the estimation or projection of number of units the company…
Q: Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur…
A: Sales means the amount recorded in books as revenue earned by selling the goods or services. Account…
Q: Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur…
A: The cash collection schedule helps to estimate the cash to be collected from customers during the…
Q: Silver Company makes a product that Is very popular as a Mother's Day gift. Thus, peak sales occur…
A: Accounts receivable at June will be amount receivable at end of June 30th
Q: Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur…
A: When sales is made on credit , cash receipts are recorded as and when the cash is collected.
Q: Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur…
A:
Q: Shamrock Shades operates in mall kiosks throughout the southwestern United States. Shamrock…
A: working note calculation of cost of goods sold(20% of sales) and ending inventory (30% of following…
Q: Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur…
A: A cash budget is considered as an estimation of expected cash receipts and disbursements based on…
Q: alam Company makes a ‘gula melaka’ chocolate mix. In the first 4 months of coming year, Talam…
A: SOLUTION- THE FOLLOWING CALCULATION ARE DONE FOR TALAM COMPANY.
Q: Anderson Labs performs a specialty lab test for local companies for $50 per test. For the upcoming…
A: January February March No. of lab tests 5900 4700 5200 x Sales per test $50 $50 $50 Sales…
Q: Ramos Co. provides the following sales forecast and production budget for the next four months:…
A: Budget:Budget refers to the financial plan for the business activities a company intends to do in…
Q: The company sells many styles of earrings, but all are sold for the same price - $10 per pair.…
A: Cash Budget is an account prepared to forecast in inflows and outflows of cash to a manufacturing…
Q: Gregor Company is preparing a budget to determine the amount of part G12 to produce for the first…
A: Lets understand the basics. Budget is prepared by the management to understand the budgeted reveue…
Q: Angelo Limited is preparing its budget for the next year. It produces and sells a single product.…
A: Following are the answers to the given questions
Q: Tillman Cycles manufactures chainless bicycles. On March 31, Tillman Cycles had 210 bikes in…
A: Here in this question, we are required to prepare production budget. Budget is a estimation of…
Q: lens junction sells lenses for 45$ and each and is estimating sales of 15,000 units in january and…
A: Particulars 15000 units in Jan 18000 units in Feb Silicion 1 unit uses 2 pounds 30000 pounds…
Q: Furniture, Inc. makes and sells a single product called a Bik. The company wants to prepare the…
A: Direct materials budget is prepared to estimate the amount of materials that must be procured by the…
Q: Hurtt’s Java Seeds is an independent roaster of specialty coffee beans. The company budgets 2 months…
A: Particular Amount beginning direct material inventory $5,000 (+) Cost of Direct Material…
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
- 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?Refer to Cornerstone Exercise 8.2 for the production budgets for practice balls and match balls. Every practice ball requires 0.7 square yard of polyvinyl chloride panels, one bladder with valve (to fill with air), and 3 ounces of glue. FlashKicks policy is that 20 percent of the following months production needs for raw materials be in ending inventory. Beginning inventory in January for all raw materials met this requirement. Required: 1. Construct a direct materials purchases budget for each type of raw materials for the practice ball line for January and February of the coming year. 2. What if FlashKick decreased the ending inventory percentage to 15 percent of the next months production needs? What impact would that have on the direct materials purchases budgets prepared in Requirement 1? Refer to Cornerstone Exercise 8.1, through Requirement 1. FlashKick requires ending inventory of product to equal 20 percent of the next months unit sales. Beginning inventory in January was 3,100 practice soccer balls and 400 match soccer balls. Required: 1. Construct a production budget for each of the two product lines for FlashKick Company for the first three months of the coming year. 2. What if FlashKick wanted a production budget for the two product lines for the month of April? What additional information would you need to prepare this budget?Refer to Cornerstone Exercise 8.1, through Requirement 1. FlashKick requires ending inventory of product to equal 20 percent of the next months unit sales. Beginning inventory in January was 3,100 practice soccer balls and 400 match soccer balls. Required: 1. Construct a production budget for each of the two product lines for FlashKick Company for the first three months of the coming year. 2. What if FlashKick wanted a production budget for the two product lines for the month of April? What additional information would you need to prepare this budget? FlashKick Company manufactures and sells soccer balls for teams of children in elementary and high school. FlashKicks best-selling lines are the practice ball line (durable soccer balls for training and practice) and the match ball line (high-performance soccer balls used in games). In the first four months of next year, FlashKick expects to sell the following: Required: 1. Construct a sales budget for FlashKick for the first three months of the coming year. Show total sales for each product line by month and in total for the first quarter. 2. What if FlashKick added a third linetournament quality soccer balls that were expected to take 40 percent of the units sold of the match balls and would have a selling price of 45 each in January and February, and 48 each in March? Prepare a sales budget for Flash- Kick for the first three months of the coming year. Show total sales for each product line by month and in total for the first quarter.
- 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?Preparing a Direct Materials Purchases Budget Patrick Inc. makes industrial solvents sold in 5-gallon drums. Planned production in units for the first 3 months of the coming year is: Each drum requires 5.5 gallons of chemicals and one plastic drum. Company policy requires that ending inventories of raw materials for each month be 15% of the next months production needs. That policy was met for the ending inventory of December in the prior year. The cost of one gallon of chemicals is 2.00. The cost of one drum is 1.60. (Note: Round all unit amounts to the nearest unit. Round all dollar amounts to the nearest dollar.) Required: 1. Calculate the ending inventory of chemicals in gallons for December of the prior year and for January and February. What is the beginning inventory of chemicals for January? 2. Prepare a direct materials purchases budget for chemicals for the months of January and February. 3. Calculate the ending inventory of drums for December of the prior year and for January and February. 4. Prepare a direct materials purchases budget for drums for the months of January and February.Cash budget The controller of Mercury Shoes 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, 60% are expected to be collected in the month following the sale and the remainder the following month (second month after sale). Depreciation, insurance, and property tax expense represent 12,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in February, and the annual property taxes are paid in November. 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 June 1 include cash of 42,000, marketable securities of 25,000, and accounts receivable of 198,000 (150,000 from May sales and 48,000 from April sales). Sales on account in April and May were 120,000 and 150,000, respectively. Current liabilities as of June 1 include 13,000 of accounts payable incurred in May for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of 24,000 will be made in July. Mercury Shoes regular quarterly dividend of 15,000 is expected to be declared in July and paid in August. Management desires to maintain a minimum cash balance of 40,000. Instructions Prepare a monthly cash budget and supporting schedules for June, July, and August. On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?
- Production budget Healthy Measures Inc. produces a Bath and Gym version of its popular electronic scale. The anticipated unit sales for the scales by sales region are as follows: The finished goods inventory estimated for March 1, for the Bath and Gym scale models is 11,800 and 8,100 units, respectively. The desired finished goods inventory for March 31 for the Bath and Gym scale models is 15,000 and 7,500 units, respectively. Prepare a production budget for the Bath and Gym scales for the month ended March 31.Preparing a Direct Labor Budget Tulum Inc. makes a Mexican chocolate mix. Planned production in units for the first 3 months of the coming year is: Each box of chocolate mix takes 0.4 direct labor hour. The average wage is 17 per hour. Required: Prepare a direct labor budget for the months of January, February, and March, as well as the total for the first quarter.Cash Budget The controller of Feinberg Company is gathering data to prepare the cash budget for July. He plans to develop the budget from the following information: a. Of all sales, 40% are cash sales. b. Of credit sales, 45% are collected within the month of sale. Half of the credit sales collected within the month receive a 2% cash discount (for accounts paid within 10 days). Thirty percent of credit sales are collected in the following month; remaining credit sales are collected the month thereafter. There are virtually no bad debts. c. Sales for the second two quarters of the year follow. (Note: The first 3 months are actual sales, and the last 3 months are estimated sales.) d. The company sells all that it produces each month. The cost of raw materials equals 26% of each sales dollar. The company requires a monthly ending inventory of raw materials equal to the coming months production requirements. Of raw materials purchases, 50% is paid for in the month of purchase. The remaining 50% is paid for in the following month. e. Wages total 105,000 each month and are paid in the month incurred. f. Budgeted monthly operating expenses total 376,000, of which 45,000 is depreciation and 6,000 is expiration of prepaid insurance (the annual premium of 72,000 is paid on January 1). g. Dividends of 130,000, declared on June 30, will be paid on July 15. h. Old equipment will be sold for 25,200 on July 4. i. On July 13, new equipment will be purchased for 173,000. j. The company maintains a minimum cash balance of 20,000. k. The cash balance on July 1 is 27,000. Required: Prepare a cash budget for July. Give a supporting schedule that details the cash collections from sales.