Mike Tackett, manager of the Troopers Café, has asked for your assistance preparing the monthlybudget for January 20X8. He provides you with the prior January actuals as follows:Sales$100.400Expenses:Labor (F)12,000Labor (V)18,000Cost of sales (V) 36,000Supplies (V)3.200Energy (V)2.620Promotion (V)1.300Maintenance (F) 2.000Maintenance (V) 1.200Property taxes (F) 800Depreciation (F) 1.000Rent (F)850Insurance (F)625Subtotal79.595Net income$20.805Assume for 20X8 sales are expected to increase by 10 percent, fixed costs will increase by 5 percent,and variable costs will remain at the same percentage of sales as experienced in the prior January.Prepare the budget for January 20X8.HOMEWORK HINT: Divide the prior January variable expenses by the prior January sales amount tocome up with the percentage of sales for each variable expense. DO NOT ROUND THEPERCENTAGEI Multiply that percentage by the January 2018 Budgeted Sales Amount (that youfigure out) to come up with the January 2018 Budgeted Variable Expense Amount.

Budget: Budget is an effective tool to achieve the financial and operational goals of the business.…

Answered: Mike Tackett, manager of the Troopers…

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter7: Budgeting

Section: Chapter Questions

Problem 1PB: Lens & Shades sells sunglasses for $37 each and is estimating sales of 21,000 units in January and...

See similar textbooks

Similar questions

Lens & Shades sells sunglasses for $37 each and is estimating sales of 21,000 units in January and 19,000 in February. Each lens consist of 2.00 mm of plastic costing $2.50 per mm, 1.7 oz of dye costing $2.80 per ounce. and 0.50 hours direct labor at a labor rate of $18 per unit. Desired inventory levels are: Prepare a sales budget, production budget, direct materials budget for silicon and solution, and a direct labor budget.
Ranger Industries has provided the following information at June 30: Other information: Average selling price, 196 Average purchase price per unit, 110 Desired ending inventory, 40% of next months unit sales Collections from customers: In month of sale20% In month after sale50% Two months after sale30% Projected cash payments: Inventory purchases are paid for in the month following acquisition. Variable cash expenses, other than inventory, are equal to 25% of each months sales and are paid in the month of sale. Fixed cash expenses are 40,000 per month and are paid in the month incurred. Depreciation on equipment is 2,000 per month. REQUIREMENT You have been asked to prepare a master budget for the upcoming quarter (July, August, and September). The components of this budget are a monthly sales budget, a monthly purchases budget, a monthly cash budget, a forecasted income statement for the quarter, and a forecasted September 30 balance sheet. The worksheet MASTER has been provided to assist you. Ranger Industries desires to maintain a minimum cash balance of 8,000 at the end of each month. If this goal cannot be met, the company borrows the exact amount needed to reach its goal. If the company has a cash balance greater than 8,000 and also has loans payable outstanding, the amount in excess of 8,000 is paid to the bank. Annual interest of 18% is paid on a monthly basis on the outstanding balance.
Cadre, Inc., sells a single product with a selling price of $120 and variable costs per unit of $90. The companys monthly fixed expenses are $180,000. What is the companys break-even point in units? What is the companys break-even point in dollars? Prepare a contribution margin income statement for the month of October when they will sell 10,000 units. How many units will Cadre need to sell in order to realize a target profit of $300,000? What dollar sales will Cadre need to generate in order to realize a target profit of $300,000? Construct a contribution margin income statement for the month of August that reflects $2,400,000 in sales revenue for Cadre, Inc.
Lens Junction sells lenses for $45 each and is estimating sales of 15,000 units in January and 18,000 in February. Each lens consists of 2 pounds of silicon costing $2.50 per pound, 3 oz of solution costing $3 per ounce, and 30 minutes of direct labor at a labor rate of $18 per hour. Desired inventory levels are: Â Prepare a sales budget, production budget. direct materials budget for silicon and solution, and a direct labor budget.
Trumbull Co. plans to produce 100,000 toy cars during September. Planned production for October is 125,000 cars. Sales are forecasted at 90,000 toy cars for September and 120,000 toy cars for October. Each toy car requires four wheels. Trumbulls policy is to maintain 10 percent of the next months production in inventory at the end of a month. How many wheels should Tram bull purchase during September? a. 195,000 b. 112,500 c. 102,500 d. 410,000
Alard Manufacturing Company has a billing department staffed by four billing clerks. Each clerk is paid 32,000 per year and is able to process 8,000 bills. Last year, 27,360 bills were processed by the four agents. Calculate the unused capacity in terms of number of bills. a. 27,360 b. 4,640 c. 8,000 d. 32,000
Maria Cohen is employed as a salesperson in the mens department of Lees Fashions. In addition to her weekly base salary of 400 (35-hour week), Cohen is paid a commission of 1% on her total net sales for the week (total gross sales less any customer returns). During the past week, to promote the sale of its fine cashmere sweaters, Lees agreed to pay Cohen an additional PM (push money) of 3% of the total net sales of cashmere sweaters. Cohens weekly sales tally is given below. Compute Cohens total weekly earnings, showing her (a) weekly base salary, (b) commission, (c) PM, and (d) total weekly earnings.
Maple Enterprises sells a single product with a selling price of $75 and variable costs per unit of $30. The companys monthly fixed expenses are $22,500. What is the companys break-even point in units? What is the companys break-even point in dollars? Construct a contribution margin income statement for the month of September when they will sell 900 units. How many units will Maple need to sell in order to reach a target profit of $45,000? What dollar sales will Maple need in order to reach a target profit of $45,000? Construct a contribution margin income statement for Maple that reflects $150,000 in sales volume.
Desiccate purchases direct materials each month. Its payment history shows that 70% is paid in the month of purchase with the remaining balance pad the month after purchase. Prepare a cash payment schedule for March if in January through March, it purchased $35,000, $37,000, and $39,000, respectively.
Marlin Motors sells a single product with a selling price of $400 with variable costs per unit of $160. The companys monthly fixed expenses are $36,000. What is the companys break-even point in units? What is the companys break-even point in dollars? Prepare a contribution margin income statement for the month of November when they will sell 130 units. How many units will Marlin need to sell in order to realize a target profit of $48,000? What dollar sales will Marlin need to generate in order to realize a target profit of $48.000? Construct a contribution margin income statement for the month of February that reflects $200,000 in sales revenue for Marlin Motors.
Halifax Shoes has 30% of its sales in cash and the remainder on credit. Of the credit sales, 65% is collected in the month of sale, 25% is collected the month after the sale, and 5% is collected the second month after the sale. How much cash will be collected in August if sales are estimated as $75,000 in June, $65,000 in July, and $90,000 in August?
On January 1, Sweet Pleasures, Inc., begins business. The company has 14,000 cash on hand and is attempting to project cash receipts and disbursements through April 30. On May 1, a note payable of 10,000 will be due. This amount was borrowed on January 1 to carry the company through its first four months of operation. The unit purchase cost of the companys single product, a box of Sweet Pleasures chocolates, is 12. The unit sales price is 28. Projected purchases and sales in units for the first four months are: Sales terms call for a 5% discount if paid within the same month that the sale occurred. It is expected that 50% of the billings will be collected within the discount period, 25% by the end of the month after purchase, 19% in the following month, and 6% will be uncollectible. Approximately 60% of the purchases are paid for in the month purchased. The rest are due and payable in the next month. Total fixed marketing and administrative expenses for each month include cash expenses of 5,000 and depreciation on equipment of 2,000. Variable marketing and administrative expenses total 6 per unit sold. All marketing and administrative expenses are paid as incurred. REQUIREMENT You have been asked to prepare a cash budget for the next four months to see if the loan can be repaid. Review the worksheet CASHBUD that follows these requirements. The problem data have already been entered in the Data Section of the worksheet.

SEE MORE QUESTIONS

Recommended textbooks for you

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

Cornerstones of Cost Management (Cornerstones Ser…

Accounting

ISBN:

9781305970663

Author:

Don R. Hansen, Maryanne M. Mowen

Publisher:

Cengage Learning

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

Cornerstones of Cost Management (Cornerstones Ser…

Accounting

ISBN:

9781305970663

Author:

Don R. Hansen, Maryanne M. Mowen

Publisher:

Cengage Learning

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

PAYROLL ACCT., 2019 ED.(LL)-TEXT

Accounting

ISBN:

9781337619783

Author:

BIEG

Publisher:

CENGAGE L

EBK CONTEMPORARY FINANCIAL MANAGEMENT

Finance

ISBN:

9781337514835

Author:

MOYER

Publisher:

CENGAGE LEARNING - CONSIGNMENT

Managerial Accounting

Accounting

ISBN:

9781337912020

Author:

Carl Warren, Ph.d. Cma William B. Tayler

Publisher:

South-Western College Pub

SEE MORE TEXTBOOKS