Suhana Corporation manufactures and sells a seasonal product that has peak sales in the third quarter. The company's single product sells for Rs. 80 per unit. Budgeted unit sales for the next six quarters are as follows (all sales are on credit): YEAR 2 YEAR 3 Quarter 01 Quarter 02 Quarter 03 Quarter 04 400,000 600,000 1,000,000 700,000 800,000 500,000 Sales are collected in the following pattern: 75% in the quarter the sales are made, and the remaining 25% in the following quarter. On January 1st, Year 2, the company's balance sheet showed Rs. 650,000 in accounts receivable, all of which will be collected in the first quarter of the year. Bad debts are negligible and can be ignored. .( don't use excel hand written answer will be accepted)

Suhana Corporation manufactures and sells a seasonal product that has peak sales in the third quarter. The company's single product sells for Rs. 80 per unit. Budgeted unit sales for the next six quarters are as follows (all sales are on credit): YEAR 2 YEAR 3 Quarter 01 Quarter 02 Quarter 03 Quarter 04 400,000 600,000 1,000,000 700,000 800,000 500,000 Sales are collected in the following pattern: 75% in the quarter the sales are made, and the remaining 25% in the following quarter. On January 1st, Year 2, the company's balance sheet showed Rs. 650,000 in accounts receivable, all of which will be collected in the first quarter of the year. Bad debts are negligible and can be ignored. .( don't use excel hand written answer will be accepted)

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter8: Budgeting For Planning And Control

Section: Chapter Questions

Problem 11CE: Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted...

See similar textbooks

Similar questions

A companys sales for the coming months are as follows: About 20 percent of sales are cash sales, and the remainder are credit sales. The company finds that typically 10 percent of a months credit sales are paid in the month of sale, 70 percent are paid the next month, and 15 percent are paid in the second month after sale. Expected cash receipts in July are budgeted at what amount? a. 114,520 b. 143,150 c. 145,720 d. 156,000
Eastman, Inc., manufactures and sells three products: R, S, and T. In January, Eastman, Inc., budgeted sales of the following. At the end of the year, actual sales revenue for Product R and Product S was 3,075,000 and 3,254,000, respectively. The actual price charged for Product R was 25 and for Product S was 20. Only 10 was charged for Product T to encourage more consumers to buy it, and actual sales revenue equaled 540,000 for this product. Required: 1. Calculate the sales price and sales volume variances for each of the three products based on the original budget. 2. Suppose that Product T is a new product just introduced during the year. What pricing strategy is Eastman, Inc., following for this product?
Barnstormer sells airplane accessories for $20 each. It expects sales of 120,000 units in quarter 1 and a 7% increase each subsequent quarter for the next 8 quarters. Prepare a sales budget by quarter for the first year.
Navigator sells GPS trackers for $50 each. It expects sales of 5,000 units in quarter 1 and a 5% increase each subsequent quarter for the next 8 quarters. Prepare a sales budget by quarter for the first year.
Pilsner Inc. purchases raw materials on account for use in production. The direct materials purchases budget shows the following expected purchases on account: Pilsner typically pays 25% on account in the month of billing and 75% the next month. Required: 1. How much cash is required for payments on account in May? 2. How much cash is expected for payments on account in June?
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.
Mynor Corporation manufactures and sells a seasonal product that has peak sales in the third quarter. Thefollowing information concerns operations for Year 2—the coming year—and for the first two quarters ofYear 3:a. The company’s single product sells for $8 per unit. Budgeted sales in units for the next six quarters areas follows (all sales are on credit):Year 3Year 2 Quarter Quarter1 2 3 4 1 2Budgeted unit sales ........... 40,000 60,000 100,000 50,000 70,000 80,000b. Sales are collected in the following pattern: 75% in the quarter the sales are made, and the remaining25% in the following quarter. On January 1, Year 2, the company’s balance sheet showed $65,000in accounts receivable, all of which will be collected in the first quarter of the year. Bad debts arenegligible and can be ignored.c. The company desires an ending finished goods inventory at the end of each quarter equal to 30% of thebudgeted unit sales for the next quarter. On December 31, Year 1, the company had 12,000…
ToraBika corporation manufactures and sells a seasonal product that has peak sales in the third quarter. The following information concerns operations for year 2-the coming year and for the first two quarters of year 3: The company’s single product sells for Tk. 10 per unit. Budgeted unit sales for the next six quarters are as follows(all sales are credit sales): year 2 quarter Year 3 quarter 1 2 3 4 1 2 40,000 units 60,000 units 1,00,000 units 50,000 units 60,000 units 70,000 units Sales are collected in the following pattern: 65% in the quarter the sales are made, and the remaining 35% in the following quarter. On January 1, year 2, the company’s balance sheet showed tk. 63,000 in accounts receivable, all of which will be collected in the first quarter of the year. Bad debts are negligible and can be ignored. c. Raw materials purchased in the following patterns: Y2 y3 Q1 Q2 Q3 Q4 Q5 Q6…
2. Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales: Quarter 1 $4,780,000 Quarter 2 5,690,000 Quarter 3 630,000 Quarter 4 8,200,000 In Shalimar’s experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are $5,080,000 and for the fourth quarter of the current year are $7,220,000. Required: Question Content Area 1. Calculate cash sales and credit sales expected in the last two quarters of the current year, and in each quarter of next year. Quarter Cash Sales Credit Sales 3, current year $fill in the blank b0590a054f99004_1 $fill in the blank b0590a054f99004_2 4, current year fill in the blank…
M/s. MNO produces cookies. The company is currently in the process of establishing a master budget on a quarterly basis for this coming fiscal year, which ends December 31. Prior year quarterly unit sales were; 40000 in quarter one, and 45000, 50000, 55000 in the subsequent quarters. Unit sales are expected to increase 25% in quarter one, and 5%, 10%, 5% in the subsequent quarters and each unit is expected to sell for Rs. 6.Required:Prepare Sales Budget
Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales: Quarter 1 $4,740,000 Quarter 2 5,860,000 Quarter 3 3,720,000 Quarter 4 8,580,000 In Shalimar’s experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are $5,410,000 and for the fourth quarter of the current year are $7,070,000. Required: Question Content Area 1. Calculate cash sales and credit sales expected in the last two quarters of the current year, and in each quarter of next year. Quarter Cash Sales Credit Sales 3, current year $fill in the blank 9d2fe401a04bf88_1 $fill in the blank 9d2fe401a04bf88_2 4, current year fill in the blank…
Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales: Quarter 1 $4,620,000 Quarter 2 5,150,000 Quarter 3 4,890,000 Quarter 4 8,480,000 In Shalimar’s experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are $5,040,000 and for the fourth quarter of the current year are $7,680,000. Required: Question Content Area 1. Calculate cash sales and credit sales expected in the last two quarters of the current year, and in each quarter of next year. Quarter Cash Sales Credit Sales 3, current year $fill in the blank 1d3d12fb3fb1016_1 $fill in the blank 1d3d12fb3fb1016_2 4, current year fill in the blank…