Bunbar Company | ||||||
Sales Budget | ||||||
For the Quarter ending June | ||||||
April | May | June | Total | |||
Budgeted Packages to be sold | 1,500 | 2,000 | 2,500 | 6,000 | ||
Sales price per Package | $22 | $22 | $22 | |||
Total sales | $33,000 | $44,000 | $55,000 | 132,000 | ||
Bunbar Company | ||||||
Production Budget | ||||||
For the Quarter ending June | ||||||
April | May | June | Total | |||
Budgeted packagess to be sold | 1,500 | 2,000 | 2,500 | 6,000 | ||
Plus :Desired ending inventory | 200 | 250 | 300 | 300 | ||
Total Packages needed | 1,700 | 2,250 | 2,800 | 6,300 | ||
Reduce Beginning Inventory | 350 | 200 | 250 | 350 | ||
Budgeted Production | 1,350 | 2,050 | 2,550 | 5,950 | ||
Desired ending inventory: | ||||||
April = May's sales * 10% = (2,000 * 10%) = 200 packages | ||||||
May = June's sales * 10% = (2,500 * 10%) = 250 packages | ||||||
June = July's sales * 10% = (3,000 * 10%) = 300 packages | ||||||
And, | ||||||
April's beginning inventory = March's ending inventory = 350 packages | ||||||
May's beginning inventory = April's ending inventory = 200 packages | ||||||
Junel's beginning inventory = May's ending inventory = 250 packages | ||||||
Dunbar Company manufactures drinking glasses. One unit is a package of eight glasses, which sels for...
Lugo Company manufactures drinking glasses. One unit is a package of eight glasses, which sells for $15. Lugo projects sales for April will be 4,500 packages, with sales increasing by 300 packages per month for May, June, and July. On Apr 1, Lugo has 150 packages on hand but desires to maintain an ending inventory of 20% of the next month's sales. Prepare a sales budget and a production budget for Lugo for April, May, and June. Begin by preparing...
Rucker Company manufactures drinking glasses. One unit is a package of eight glasses, which sells for $15. Rucker projects sales for April will be 4,000 packages, with sales increasing by 100 packages per month for May, June, and July. On April 1, Rucker has 175 packages on hand but desires to maintain an ending inventory of 10% of the next month's sales. Prepare a sales budget and a production budget for Rucker for April, May, and June April, May, and...
Rucker Company manufactures drinking glasses. One unit is a
package of eight classes, which sells for $14. Rucker projects
sales for April will be 1,500 pages with sales increasing by 50
packages per month for May, June, and July. On April 1, Rucker has
25 packages on hand but desires to maintain an ending inventory of
10% of the next month's sales. Prepare a sales budget and a
production budget for Rucker for April, May, and June.
Rucker Company manufactures...
RE22-23 (similar to) Question Help Totum Company manufactures drinking glasses. One unit is a package of eight glasses, which sets for $10.Tatum project sales for April will be 3.000 packages, with sales increasing ty 250 packages per month for May June and on April 1, Tatum has 400 packages on hand but desires to maintain an ending invertory of 20% of the next mont's sales Prepare a sales budget and a production budget for Totum for April May, and June...
Now assume that Rockers's sales are collected as follows: Rockers expects total sales of $700,500 for January and $352,000 for February. November sales totaled $400,000 and December sales were $402,000. 40% in the month of the sale The following schedule of cash receipts for January and February was prepared based upon the collection history given: i (Click the icon to view the collection history.) (Click the icon to view the schedule of cash receipts.) 30% in the month of the...
Yogi expects total sales of $362,000 in January and $394,000 in February. Yogi has the following schedule of cash receipts: (Click on the icon to view the schedule of cash receipts.) Now assume that Yogi's sales are collected as follows: (Click on the icon to view new cash receipts assumptions.) November sales totaled $350,000, and December sales were $340,000. Prepare a revised schedule of cash receipts for January and February. Round answers to the nearest dollar. (If a box is...
Victors expects total sales of $699,000 for January and $348,000 for February. November sales totaled $388,000 and December sales were $402,000. Now assume that Victors's sales are collected as follows: 60% in the month of the sale The following schedule of cash receipts for January and February was prepared based upon the collection history given: A (Click the icon to view the collection history.) 20% in the month after the sale 16% two months after the sale E (Click the...
Berry expects total sales of $359,000 in January and $405,000 in February. Assume that Berry's sales are collected as follows: (Click the icon to view the collections.) November sales totaled $350,000, and December sales were $325,000. Prepare a schedule of cash receipts from customers for January and February. Round answers to the nearest dollar. (If a box is not used in the table leave the box empty, do not enter a zero.) Cash Receipts from Customers January February Total sales...
Please answer the following. Thanks.
Grippers expects total sales of $701,500 for January and $355,000 for February November is totale $393,000 and December sales were $409,000 The following schedule of cash receipts for January and February was prepared based upon the collection history given (Click the icon to view the collection history) Click the icon to view the schedule of cash receipts.) Now assume that Gripper's sales are collected as follows: 30% in the month of the sale 20% in...
Yeaman expects total sales of $333,000 in January and $407,000 in February. Yeaman has the following schedule of cash receipts: Now assume that Yeaman's sales are collected as follows: (Click on the icon to view new cash receipts assumptions.) November sales totaled $260,000, and December sales (Click on the icon to view the schedule of cash receipts.) were $330,000. Prepare a revised schedule of cash receipts for January and February. Round answers to the nearest dollar Data Table (If a...