Question

In: Accounting

Information pertaining to ABC Company's sales budget is as follows: October November   December Unit sales               ...

Information pertaining to ABC Company's sales budget is as follows:
October November   December
Unit sales                1,800               2,000            2,800
Unit sale price $           10.00
Credit card sales 60%
Cash sales 40%
Fees paid to credit card companies 3%
Cost of goods sold 40% of net sales
Note: Net sales is gross sales less fees paid to credit card companies.
Required:
Compute the budgeted sales revenue, cost of goods sold and  
gross margin for the month of November.

Solutions

Expert Solution

Answer to Q1

Total Budgeted Sales Revenue : Number of units * Sales Per unit

= 2,000*$10 ; $20,000

Fees Paid to Credit card company : Total Sales *3% ; $20,000*3%

= $600

Net Budgeted Revenue : Total Budgeted Sales - Fees Paid to credit card company

= $20,000-$600 ; $19,400

Cost of Goods sold : 40% on Total Budgeted Revenue

= $20,000*40% ; $8,000

Gross Margin : Net sales - Cost of Goods sold ; $19,400- $8,000

= $11,400

Note: The Price per unit is visible in the question screen is $10 & sales units are 2,0 asuumming it is 2,000 for november (attached screenshot if the question in case it is different have to change it in the calculation to re run the gross margin)


Related Solutions

Information pertaining to Noskey Corporation’s sales revenue follows: November 2018 (Actual) December 2018 (Budgeted) January 2019...
Information pertaining to Noskey Corporation’s sales revenue follows: November 2018 (Actual) December 2018 (Budgeted) January 2019 (Budgeted) Cash sales $ 80,000 $ 100,000 $ 60,000 Credit sales 240,000 360,000 180,000 Total sales $ 320,000 $ 460,000 $ 240,000 Management estimates 5% of credit sales to be uncollectible. Of collectible credit sales, 60% is collected in the month of sale and the remainder in the month following the month of sale. Purchases of inventory each month include 70% of the next...
Information pertaining to Noskey Corporation’s sales revenue follows: November 2015 (Actual) December 2015 (Budgeted) January 2016...
Information pertaining to Noskey Corporation’s sales revenue follows: November 2015 (Actual) December 2015 (Budgeted) January 2016 (Budgeted)   Cash sales $ 155,000   $ 145,000     $ 90,000     Credit sales 330,000   465,000     240,000     Total sales $ 485,000 $ 610,000     $ 330,000     Management estimates 5% of credit sales to be uncollectible. Of collectible credit sales, 60% is collected in the month of sale and the remainder in the month following the month of sale. Purchases of inventory each month include 70% of the...
Information pertaining to Yekstop Corp.'s sales revenue is presented below: November December January Cash sales $...
Information pertaining to Yekstop Corp.'s sales revenue is presented below: November December January Cash sales $ 98,000 $ 127,000 $ 80,000 Credit sales 290,000 452,000 236,000 Total sales $ 388,000 $ 579,000 $ 316,000 Management estimates that 5% of credit sales are eventually uncollectible. Of the collectible credit sales, 65% are likely to be collected in the month of sale and the remainder in the month following the month of sale. The company desires to begin each month with an...
nformation pertaining to Noskey Corporation’s sales revenue follows: November 2018 (Actual) December 2018 (Budgeted) January 2019...
nformation pertaining to Noskey Corporation’s sales revenue follows: November 2018 (Actual) December 2018 (Budgeted) January 2019 (Budgeted) Cash sales $ 180,000 $ 160,000 $ 100,000 Credit sales 360,000 500,000 260,000 Total sales $ 540,000 $ 660,000 $ 360,000 Management estimates 5% of credit sales to be uncollectible. Of collectible credit sales, 60% is collected in the month of sale and the remainder in the month following the month of sale. Purchases of inventory each month include 70% of the next...
Sales Unit sales for November 2019 111,000 Unit sales for December 2019 101,000 Expected unit sales...
Sales Unit sales for November 2019 111,000 Unit sales for December 2019 101,000 Expected unit sales for January 2020 112,000 Expected unit sales for February 2020 112,000 Expected unit sales for March 2020 116,000 Expected unit sales for April 2020 125,000 Expected unit sales for May 2020 138,000 Unit selling price $12 Waterways likes to keep 10% of the next month’s unit sales in ending inventory. All sales are on account. 85% of the Accounts Receivable are collected in the...
ABC Company has the following forecasts: Month Sales Forecast( $000) October 2017 $1,000 November 1,500 December...
ABC Company has the following forecasts: Month Sales Forecast( $000) October 2017 $1,000 November 1,500 December 3,000 Notes: All sales are made on credit terms of net 30 days and are collected all in the following month; There is $700 accounts receivable at the end of September; Inventory on hand represents a safety stock level and will be maintained. Inventory is purchased in the month of sale and paid for in cash. Cost of goods sold average 80 percent of...
Question 3 Information pertaining to Yekstop Corp.'s sales revenue is presented below: November December January Cash...
Question 3 Information pertaining to Yekstop Corp.'s sales revenue is presented below: November December January Cash sales $ 105,000 $ 134,000 $ 87,000 Credit sales 297,000 459,000 243,000 Total sales $ 402,000 $ 593,000 $ 330,000 Management estimates that 3% of credit sales are eventually uncollectible. Of the collectible credit sales, 60% are likely to be collected in the month of sale and the remainder in the month following the month of sale. The company desires to begin each month...
Prepare a selling and administrative expenses budget. October November December Selling and Administrative Expense Budget Salary...
Prepare a selling and administrative expenses budget. October November December Selling and Administrative Expense Budget Salary expense Sales commissions Supplies expense Utilities Depreciation on store fixtures Rent Miscellaneous Total S&A expenses $0 $0 $0 Required information Problem 14-23 Preparing a master budget for retail company with no beginning account balances LO 14-2, 14-3, 14-4, 14-5, 14-6 [The following information applies to the questions displayed below.] Munoz Company is a retail company that specializes in selling outdoor camping equipment. The company...
Khaled Industries, a defense contractor, is developing a cash budget for October, November, and December. (i)...
Khaled Industries, a defense contractor, is developing a cash budget for October, November, and December. (i) Khaled’s sales in August and September were $100,000 and $200,000 respectively. Forecasted Sales for October, November, and December are as below: October - $400,000 November - $300,000 December - $200,000 30% of the firm’s sales have been for cash, 50% have been collected after 1 month, and the remaining 20% after 2 months. Bad-debt expenses (uncollectible accounts) have been negligible. In December, Khaled will...
LearnCo Sales Budget LearnCo Sales Budget For the Year Ending December 31, 20Y2 Product Unit Sales...
LearnCo Sales Budget LearnCo Sales Budget For the Year Ending December 31, 20Y2 Product Unit Sales Volume Unit Selling Price Total Sales Basic Abacus 36000 $8 $288,000 Deluxe Abacus 36000 12 432,000 Totals 72,000 $720,000 Production Budget LearnCo Production Budget For the Year Ending December 31, 20Y2 Units Basic Units Deluxe Expected units to be sold (from Sales Budget) 36000 36000 Desired ending inventory, December 31, 20Y2 1,000 3,000 Total units available 37000 39000 Estimated beginning inventory, January 1, 20Y2...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT