Concept explainers
Edington Electronics Inc. produces and sells two models of pocket calculators. XQ-103 and XQ-104. The calculators sell for $15 and $25, respectively. Because of the intense competition Edington faces, management budgets sales semiannually. Its projections for the first 2 quarters of 2017 are as follows.
Unit Sales | ||
Product | Quarter 1 | Quarter 2 |
XQ-103 | 20,000 | 22,000 |
XQ-104 | 12,000 | 15,000 |
No changes in selling prices are anticipated.
Instructions
Prepare a sales budget for the 2 quarters ending June 30, 2017. List the products and show for each quarter and for the 6 months, units, selling price, and total sales by product and in total.
Want to see the full answer?
Check out a sample textbook solutionChapter 9 Solutions
Managerial Accounting: Tools for Business Decision Making
Additional Business Textbook Solutions
Cost Accounting (15th Edition)
Horngren's Financial & Managerial Accounting, The Financial Chapters (Book & Access Card)
Financial Accounting (12th Edition) (What's New in Accounting)
Principles of Accounting Volume 2
Managerial Accounting (5th Edition)
Construction Accounting And Financial Management (4th Edition)
- Assumptionsi. Suppliers of “old” laptop units will allow one month’s credit.ii. Customers are expected to take two months’ credit.iii. Wages will be paid as they are incurred in production.iv. Fixed overhead costs will be paid as they are incurred.v. The stock of finished goods at the end of each quarter will besufficient to satisfy 20% of the planned sales of the followingquarter.vi. The stock of “old” laptop units will be held constant at 1,000units.vii. It may be assumed that the year is divided into quarters ofequal length and that sales, production and purchases arespread evenly throughout any quarter. RequiredProduce, for each quarter of the first year of operations:(a) The cash budget (show all workings).arrow_forwardA company is considering switching from a cash only policy to a net 30 credit policy. The price per unit is $800 and the variable cost per unit is $600. The company currently sells 1,000 units per month. Under the proposed policy the company expects to sell 1,500 units per month. The quarterly compounded APR is 16%. If you were using NPV analysis to decide whether the company should switch to the net 30 (1-month) credit policy, what amount would you use for the cost of switching? (Do not round intermediate calculations. Round the final answer to 2 decimal places. Omit any commas and the $ sign in your response. For example, an answer of $1,234,567.89 should be entered as 1234567.89.) Numeric Responsearrow_forwardhollow company manufactures and sells one product only. following financial information have been obtained for next four quarters of the year 2016: quarter-1 quarter-2 quarter-3 quarter-4 sales in units 300 400 400 600 further information price will remain for the first and second quarter rs. 200 and third and fourth quarter rs. 190 for each product respectively. sales at 70% realized in the quarter of sales. balance 30% realized in the next quarter. required: a sales budget, including a schedule of expected cash receipts for the year 2016arrow_forward
- A company is considering switching from a cash only policy to a net 30 credit policy. The price per unit is $700 and the variable cost per unit is $600. The company currently sells 1,000 units per month. Under the proposed policy the company expects to sell 1,200 units per month. The quarterly compounded APR is 15%. If you were using NPV analysis to decide whether the company should switch to the net 30 (1-month) credit policy, what amount would you use for the present value of the incremental cash flows?arrow_forwardThe Lumber Yard has projected the sales below for the next four months. The company collects 37 percent of i sales in the month of sale, 44 percent in the month following the month of sale, 16 percent two months after the month of sale, and never collects 3 percent of its sales. How much will the company collect in April? April January February March Sales $137,900 $144,400 $151,975 $166,000 Multiple Choice O $152,375 $155,530 $119,767 $148,365arrow_forwardBalboa Enterprises currently sells 13,650 units a month for total monthly sales of $272,863.50. The company is considering replacing its current cash only credit policy with a net 30 policy. The variable cost per unit is $11.30 and the monthly interest rate is 1 percent. What is the switch break-even level of sales? 13,492 units 13,525 units 13,600 units 13,968 units 14,069 unitsarrow_forward
- MM Co. predicts sales of $31,000 for May. MM Co. pays a sales manager a monthly salary of $3,100 plus a commission of 8% of sales dollars. MM's production manager recently found a way to reduce the amount of packing MM uses. As a result, MM's product will receive better placement on store shelves and thus May sales are predicted to increase by 10%. In addition, MM's shipping costs are predicted to decrease from 6% of sales to 5% of sales. Compute (1) budgeted sales and (2) budgeting selling expenses for May assuming MM switches to this more sustainable packaging. What are the results for (1) and (2) (1) budgeted sales (2) Budgeted selling expensesarrow_forwardTexas Rex sells t-shirts. Expected sales for each quarter is 1000, 1200, 1500, and 2000 t-shirts at $10.00 each. They anticipate no price change. Texas Rex expects the following Cash Receipts in each quarter:     Q1         Q2           Q3          Q4                           $10,600          $11,850       $14,775      $19,625 Texas Rex believes the amount of cash needed for payments on account for raw materials each quarter is:   Q1                    Q2                         Q3                         Q4                          $4,594             $5,039                  $6,219                  $6,819 The Cash Budget is critically important to the survival of businesses. It tells management how much cash is available and shortfalls of cash need to be anticipated and handled through expense reductions or financing. Assume that Texas Rex’s beginning cash balance is $5200. The company requires a $1000 minimum cash balance…arrow_forwardAustin Computers company sales in December 2018 were $80,000 and they are expected to rise by $5,000 per month for the next 5 months. Of sales, 80 per cent are collected during the month of sale and the rest two months after sales. The cost of sales is 60 per cent of sales and, the company plans to keep an inventory at the end of each month equal to 40 per cent of the anticipated sales for the next month’s sales. Suppliers are paid one month after purchases are made. Monthly wages amount to $4,500, rent and heating $750 and depreciation $600. A machine is to be bought in March for $6,000 paid in cash. The purchase of the machine means that the monthly change for depreciation will increase by $40. The inventory held at January 1st is $15,500.  Required: Calculate the estimated cash collection from sales for February and March. Calculate the purchases for February and March. Assuming that the cash balance at 31/01/2019 is $10,000; prepare a cash budget for the two months ending March…arrow_forward
- MM Co. predicts sales of $45,000 for May. MM Co. pays a sales manager a monthly salary of $4,200 plus a commission of 6% of sales dollars. MM's production manager recently found a way to reduce the amount of packaging MM uses. As a result, MM's product will receive better placement on store shelves and thus May sales are predicted to increase by 9%. In addition, MM's shipping costs are predicted to decrease from 4% of sales to 2% of sales. Compute (1) budgeted sales and (2) budgeted selling expenses for May assuming MM switches to this more sustainable packaging. Answer is not complete. (1) Budgeted sales (2) Budgeted selling expensesarrow_forwardD’Lightful Lamp Company manufactures lamps. The estimated number of lamp sales for the last three months of the year are as follows: Month Sales October 10,000 November 14,000 December 13,000  Finished goods inventoryat the end of September was 3,000 units. Ending finished goods inventory is budgeted to equal 25 percent of the next month's sales. The company expects to sell the lamps for $25 each. January 2018 sales is projectedat 16,000 lamps. What is the expected revenue for the three months from October to December?  Question 17 options:  1) $250,000  2) $925,000  3) $325,000  4) $343,750arrow_forwardKate's Kale Chips produces a healthy snack made primarily of kale. Each bag of the product sells for $5. The company computes the manufacturing overhead rate on a quarterly basis based upon the planned number of units to be produced that quarter. The following data are from the projections of Kate's Kale Chips for the upcoming quarter: Projections 24,000 bags 26,000 bags $ 2.80 $ 0.55 $ 59,800 $ 22,000 Sales Production Variable manufacturing cost per bag Sales and distribution costs per bag Total fixed manufacturing overhead Fixed administrative overhead Required: 1. Compute the projected product cost per bag produced under full costing. 2. Compute the projected product cost per bag under variable costing. (Round your answers to 2 decimal places.) 1. Product cost under full costing per bag 2. Product cost under variable costing per bagarrow_forward
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning