The home buyer is planning their basic towel assortment for the fall season. The sales plan is $304,800 with a planned turnover for the fall season of 0.96. The planned sales by month are: August $44,450 September $57,150 October $47,625 November $63,500 December $76,200 January $28,575 Calculate the basic stock needed for each month.
Q: Prepare a quarterly production budget. Assume that the sales forecast for the first quarter of the…
A: The production budget is prepared to know how much production should be done in order to support the…
Q: The management of Sheffield Industries estimates that credit sales for August, September, October,…
A: Cash collection means the amount of money estimated to be collected by the entity from the sales of…
Q: Croy Incorporated has the following projected sales for the next five months: Month April May June…
A: The budget is prepared to estimate the requirements for the period. The materials budget is prepared…
Q: Schrank Company is trying to decide how many units of merchandise to order eoch month. Compony…
A: The budget is prepared to estimate the requirements for the period. The purchase budget is prepared…
Q: 6. Karmee’s cost of goods sold averages 40 percent of the sales value. Karmee’s objective is to…
A: Beginning inventory of February = February sales x cost of goods sold x % inventory =…
Q: Paymore Products places orders for goods equal to 75% of its sales forecast in the next quarter.…
A: Understanding how to calculate orders based on sales forecasts is crucial for businesses to manage…
Q: Nowlin Pipe & Steel has projected sales of 19,600 pipes this year, an ordering cost of $5 per order,…
A: The EOQ is the point at which the total costs of ordering and carrying inventory are at a minimum.…
Q: Croy Incorporated has the following projected sales for the next five months: Month April May June…
A: The number of units budgeted to be produced can be calculated by reducing the beginning inventory…
Q: Tiny Corp has the following information: Inventory at the end of May, for example, was only 40…
A: Solution: Number of units that Tiny must produce in June and July are present in the following…
Q: Dora Distribution has projected the following quarterly sales. The accounts receivable at the…
A: The average number of days needed to gather the due amount from clients or customers can be defined…
Q: Raw material purchases cost $ tA
A: The production budget, which establishes the number of products that must be produced, is created by…
Q: All sales are made on credit terms of net 30 days and are collected the following month and no bad…
A: Income statement means a statement which shows the expenses and revenue of the organisation during a…
Q: Skyland Company wants an ending inventory each month equal to 24% of that month's cost of goods…
A: Step 1:Computation of the desired ending inventory at the end of February: Desired ending inventory=…
Q: Finished goods inventory at the end of September is expected to be 3,000 units. Finished goods…
A: Lets understand the basics. Management prepare budget in order to estimate future profit and loss…
Q: Wildhorse Ltd. estimates sales for the second quarter of 2022 will be as follows. Month April May…
A: The production budget, which establishes the number of products that must be produced, is created by…
Q: Mario's Record Shop, a retail store, has an average gross profit ratio of 30 percent. The sales…
A: The purchases budget can be calculated using the following formula: Purchases = (Cost of Sales +…
Q: The CFO of an internet service provider gets the estimates of the company's sales forecast for the…
A: Cash flow is an important part of a business's financial planning and represents the income of a…
Q: Musselman Kennels had sales for the months of January through April of $150, $100, $120, and $200,…
A: To calculate the cash inflows for April, the total cash Musselman Kennels will receive from sales…
Q: March 45,000 85% of sales are collected in the month of the sale and the remainder is collected in…
A: particulars amount $ Cash balance $ 25,000.00 add:customer collection $58,950…
Q: CO, SRL anticipates the following sales in the given months: March 42,000 units April 59,000 units…
A: The manufacturing companies have to plan the required production levels for future so as to meet the…
Q: Shadee Corporation expects to sell 570 sun shades in May and 440 in June. Each shades sells for $12.…
A: CASH BUDGET A cash budget is an estimation of the cash flows of a business over a specific period…
Q: The management of Marigold Industries estimates that credit sales for August, September, October,…
A: The cash collection is done as per the collection schedule. Collection for October include 25% of…
Q: The Chani Company had the following sales forecast: January February March April 440 500 380 300 The…
A: Purchase budget:- This budget is prepared to estimate the number of units and cost of purchase…
Q: Croy Inc. has the following projected sales for the next five months: Month Sales in Units April…
A: Budgeted production means how much units needs to be produced to achieve sales target and keeping…
Q: eat Logos buys logo-imprinted merchandise and then sells it to university bookstores. Sales are…
A: The budget is prepared to estimate the requirements for the period. The cost of goods sold records…
Q: Furniture, Inc., estimates the following number of mattress sales for the first four months of 2021:…
A: Production budget is based on the expected sales units. This budget is prepared to predict the units…
Q: next month's sales. How many mattresses should be produced in the first quarter of 2019?
A: Production Budget The production budget calculates the number of units of products manufactured by a…
Q: Cahulilla Corporation predicts the following sales in units for the coming four months: April May…
A: Lets understand the basics.Management prepares budget in order to estimate future profit and…
Q: A merchandiser plans to sell 12,100 units next month at a selling price of $110 per unit. It also…
A: Contribution margin is the difference between total sales revenue and total variable cost. It is…
Q: Brooklyn Studio's sales are all made on account. The firm's collection experience has been that 29%…
A: Calculation of cash collection in November and December month are as follows
Q: The Lumber Yard has projected the sales below for the next four months. The company collects 37…
A: The credit sales are said to be the major component of cells for the entity because it help the…
Q: A buyer estimates that a reserve of 35 pairs of jeans is needed. She plans to reorder stock every 2…
A: Annual sales=Sales per week*52 weeks in a year =20*52 =1040 Lead time = 1 week Sales in a week=20…
Q: Oriental Lamp Co. manufactures lamps. The estimated number of lamp sales for the last three months…
A: Budgeting -Budgeting is a technique used by the organization to estimate future sales and expenses.…
Q: Wright Lighting Fixtures forecasts its sales in units for the next four months as follows: March…
A: The production budget is referred as a detailed plan that outlines number of units the company needs…
Q: On January 1 the company had 330 widgets in finished good inventory. The company policy is to…
A: As the question specifies that the closing stock for every month would be 15% of its next month…
Q: Paddle Up, a retailer of paddle boards, has provided you with the following information: Budgeted…
A: Number of units purchased in the month of February = 150 units x 80% + 110 units x 20%…
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
- Furniture, Inc., estimates the following number of mattress sales for the first four months of 2024: Month Sales January 10,000 February 14,000 March 13,000 April 16,000 Finished goods inventory at the end of December is 3,000 units. Target ending finished goods inventory is 30% of the next month's sales. How many mattresses need to be produced in January 2024? A) 8,800 mattresses B) 11,200 mattresses C) 13,000 mattresses D) 14,200 mattressesJenny Inc. has the following projected costs for the second quarter of 20YY: Projected Costs Expenses April May June Selling and marketing expenses (i) $200,000 $250,000 $300,000 Office insurance expense (ii) 800 800 800 Office depreciation expense 500 500 500 Property tax expense (iii) 700 700 700 Jenny’s payment policy for selling and administrative expenses is as follows: Of the selling and marketing expenses, 50% is paid in the month they are incurred; the remaining 50% to be paid in the following month. The selling and admin expense payable at the end of March was $70,000, which represents 50% of March’s selling expenses. Insurance expense is $800 a month; however, the insurance is paid quarterly in the first month of each quarter, (i.e., in January, April, July, and October). Property taxes are paid once a year in December. The projected total selling and admin expenses for April are: Group of answer choices None of the above $172,400 $202,000 $204,400All sales are made on credit terms of net 30 days and are collected the following month and no bad debts are anticipated. The accounts receivable on the balance sheet at the end of September thus will be collected in October. The October sales will be collected in November, and so on. Inventory on hand represents a minimum operating level (or “safety” stock), which the company intends to maintain. Cost of goods sold average 80 percent of sales. Inventory is purchased in the month of sale and paid for in cash. Other cash expenses average 7 percent of sales. Depreciation is $10,000 per month. Assume taxes are paid monthly and the effective income tax rate is 40 percent for planning purposes. The annual interest rate on outstanding long-term debt and bank loans (notes payable) is 12%. There are no capital expenditures planned during the period, and no dividends will be paid. The company’s desired end-of-month cash balance is $80,000. The president hopes to meet any cash shortages during…
- The table contains the Sales estimates for the next year. Sales are collected as follows:In the month of Sales: 43%In the next month: 23%After 2 months: 14%After 3 months: remainder is collected What is the cash collection for November? Month Sales $ Month Sales $ Jan 28,555 July 36,215 Feb 21,027 Aug 19,907 Mar 19,907 Sep 28,555 Apr 36,215 Oct 19,907 May 28,555 Nov 21,027 June 21,027 Dec 36,215The beginning inventory is expected to be 3,100 cases. Expected sales are 13,300 cases, and the company wishes to begin the next period with an inventory of 2,100 cases. The number of cases the company must purchase during the month isXYZ Company prices its products by adding 30% to its cost. XYZ anticipates sales of $715,000 in March, $728,000 in April, and $624,000 in May. XYZ’s policy is to have on hand enough inventories at the end of the month to cover 25% of the next month’s sales. What will be the cost of the inventory that ABC should budget for purchases in April? Solution: Cost of Inventory = Sales price/1.3 March cost of inventory $715,000/1.3 $550,000 April cost of inventory $728,000/1.3 $560,000 May cost of inventory $624,000/1.3 $480,000 Ending Inventory = Beginning inventory + purchases – cost of goods sold (cogs) April ending inventory $480,000 x 25% $120,000 Beginning inventory $560,000 x 25% $140,000 $120,000 = $140,000 + purchases – cost of goods sold (cogs)
- The following is a schedule of the projected unit sales of Western Company, which manufactures casual wear. Each unit sells for $25. The company began the period with a beginning accounts receivable balance of $10,000. Choose the correct answer from the options provided. Budgeted unit sales Percentage of sales collected in the quarter of the sale Percentage of sales collected in the quarter after the sale. Quarter First Second Third Fourth 1,500 1,300 1,400 1,300 Knowledge Check 01 What is the amount of budgeted sales revenue for the fourth quarter? O $32,500 $33,750 O $35,000 $37,500 $8,125 O $8,750 O $9,375 O $28,125 Year 5,500 75% 25% Knowledge Check 02 What is the amount of cash that is expected to be collected during the second quarter as a result of sales made during the first quarter?Ecology Co. sells a biodegradable product called Dissol and has predicted the following sales for the first four months of the current year: Sales in units O 3,010 O 3,100 O 3,190 O 2,830 O 3,700 Jan. 2,500 Ending inventory for each month should be 15% of the next month's sales, and the December 31 inventory is consistent with that policy. How many units should be purchased in February? Question 8 Feb. 3,100 March. 3,700 April. 2,800 F6 F7 F8FreshPak Corporation manufactures two types of cardboard boxes used in shipping canned food, fruit, and vegetables. The canned food box (type C) and the perishable food box (type P) have the following material and labor requirements. Type of Box Direct material required per 100 boxes: Paperboard ($0.30 per pound) Corrugating medium ($0.15 per pound). Direct labor required per 100 boxes ($18.00 per hour). Indirect material Indirect labor Utilities Property taxes Insurance Depreciation. Total C $12,150 95,850 31,500 21,000 16,000. 33,500 $210,000 Total 40 pounds 30 pounds 0.25 hour The following production-overhead costs are anticipated for the next year. The predetermined overhead rate is based on a production volume of 400,000 units for each type of box. Production overhead is applied on the basis of direct-labor hours. The following selling and administrative expenses are anticipated for the next year. Salaries and fringe benefits of sales personnel. Advertising $115,500 23,500…
- Wiggles Right forecasted sales of $5,000 in October, $4,000 in November, and $4,000 in December. All sales are on credit. 40% is collected the month of sale, and the remainder the following month. How much is collected from accounts receivable in November? Group of answer choices $6,000 $4,600 $5,400 $4,800Monthly sales for the Garden Centre are shown in the table below. Garden CentreSales Forecast Month Sales January $20,000 February $22,000 March $26,000 April $30,000 May $35,000 June $40,000 The Garden Centre purchases inventory two months in advance. They pay for 50% of the merchandise the month after the purchase, and the other 50% two months after the purchase. The Garden Centre’s gross margin is 40%. What are the Garden Centre’s payments to suppliers in March? Please avoid image based solutions thank youJenny Inc. has the following projected costs for the second quarter of 20YY: Projected Costs Expenses April May June Selling and marketing expenses (i) $200,000 $250,000 $300,000 Office Insurance expense (ii) 800 800 800 Office depreciation expense 500 500 500 Property tax expense (iii) 700 700 700 Jenny’s payment policy for selling and administrative expenses is as follows: Of the selling and marketing expenses, 50% is paid in the month they are incurred; the remaining 50% to be paid in the following month. The selling and admin expense payable at the end of March was $70,000, which represents 50% of March’s selling expenses. Insurance expense is $800 a month; however, the insurance is paid quarterly in the first month of each quarter, (i.e., in January, April, July, and October). Property taxes are paid once a year in December. The cash payments for selling and admin expenses projected in the month of April are: Group of answer choices None of the above $202,000…