You have been recently hired as general manager of Lucky's. It is September 1, and you must prepare the operating budget of this establishment for the first quarter of the upcoming calendar year, and submit it to the corporate office. Since you have been at the operation for only a month or so, you must rely solely on historical data. You gather sales reports and records for the months of January through August of the current year. Using the data provided, prepare the operating budget for Lucky's for the months of January through March of the upcoming year. Here is the information you determined from the most recent sales and costs records: Sales are 10 percent higher than those of the same month during the previous year. Food cost percentage is steady at 32 percent. Fixed labor costs are steady at $9,000 per month. Variable labor costs are 15 percent of sales. Occupancy costs will remain steady at $2,000 per month. Other controllable costs are expected to be $10,000 per month. Marketing costs have been fixed at $1,000 per month. Fot January, February, and March of last year, Lucky's sales revenues were as follows: o Jamuary: S60,000. o February: $50,000 March: $55,000

You have been recently hired as general manager of Lucky's. It is September 1, and you must prepare the operating budget of this establishment for the first quarter of the upcoming calendar year, and submit it to the corporate office. Since you have been at the operation for only a month or so, you must rely solely on historical data. You gather sales reports and records for the months of January through August of the current year. Using the data provided, prepare the operating budget for Lucky's for the months of January through March of the upcoming year. Here is the information you determined from the most recent sales and costs records: Sales are 10 percent higher than those of the same month during the previous year. Food cost percentage is steady at 32 percent. Fixed labor costs are steady at $9,000 per month. Variable labor costs are 15 percent of sales. Occupancy costs will remain steady at $2,000 per month. Other controllable costs are expected to be $10,000 per month. Marketing costs have been fixed at $1,000 per month. Fot January, February, and March of last year, Lucky's sales revenues were as follows: o Jamuary: S60,000. o February: $50,000 March: $55,000

Managerial Accounting

15th Edition

ISBN:9781337912020

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

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

Chapter8: Budgeting

Section: Chapter Questions

Problem 20E

See similar textbooks

Similar questions

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?
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.
You have been recently hired as general manager of Lucky’s. It is September 1, and you must prepare the operating budget of this establishment for the first quarter of the upcoming calendar year, and submit it to the corporate office. Since you have been at the operation for only a month or so, you must rely solely on historical data. You gather sales reports and records for the months of January through August of the current year. Using the data and the budget worksheet provided, prepare the operating budget for Lucky’s for the months of January through March of the upcoming year. Here is the information you determined from the most recent sales and costs records (Please note that the first month has already been completed): Sales are 10 percent higher than those of the same month during the previous year. Food cost percentage is steady at 32 percent. Fixed labor costs are steady at $9,000 per month. Variable labor costs are 15 percent of sales. Occupancy costs will remain steady…
Can you give me the step by step answers on how to compute this: An excel spreadsheet would be amazing... ProblemThe treasurer of Bradly Lawn Equipment Company instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: August September OctoberSales $310,000 $390,000 $366,000Manufacturing costs 190,000 240,000 215,000Operating expenses 56,000 71,000 65,000Capital expenditures 24,000 The company expects to sell about 20% of its merchandise for cash. Of sales on account, 70% are expected to be collected in full in the month following the sale and the remainder the following month. Depreciation, insurance, and property taxes represent $20,000 of the estimated monthly manufacturing costs and $4,000 of the probable monthly operating expenses.¬ The annual insurance premium is paid in July, and the annual property taxes are paid in November. Of the remainder of the manufacturing costs and operating expenses, 80% are…
Please do provide the solution for the correct answer. Thank you! Following is the sales budget of BULAKLAK Company for the period January toJune 2014: Months UnitsJanuary 100,000February 90,000March 90,000April 80,000May 70,000June 70,000 The company's projection is to have inventory on hand at the end of each monthequal to 70% of the sales for the month following. It is assumed that the inventoryat the end of December 2013 will meet this requirement. It is also estimated thatthe 80,000 units will be sold in July 2014. What is the total production budget inunits for the six months period ending June 30, 2014?a. 556,000 b. 486,000 c. 524,000 d. 479,000
4. Use the information below for Nuthatch Corporation to answer the question that follow. Nuthatch Corporation began its operations on September 1 of the current year. Budgeted sales for the first three months of business—September, October, and November—are $245,000, $308,000, and $412,000, respectively. The company expects to sell 30% of its merchandise for cash. Of sales on account, 80% are expected to be collected in the month of the sale and 20% in the month following the sale. The cash collections expected in October from accounts receivable are estimated to be a.$138,180 b.$206,780 c.$172,480 d.$248,136
Joy is a company that manufactures a product called”Gladys”. The company is contemplating engaging an MBA graduate to manage its budgets. The following information is unveiled to you for the six months period ended 31st December 2021: July August September October November December Sales(Units) 480 520 640 750 700 600 Production(Units) 550 500 700 720 715 510 Additional data: (i) The selling price per unit is set at K13,800 per unit for July, August and September and K14,900 for October, November and December. (ii) The sales policy is to receive 65% of the sales value in the month of sale and the balance the month after sale. (iii) Purchases for production are used in the month of purchase and paid for one month after purchase. The cost per unit has been set at K8,300 for July and August,K8,700 for September and October and…
4. Bureda makes all purchases on account, subject to the following payment pattern:Paid in the month of purchase ......................... 30%Paid in the first month following purchase ............ 65%Paid in the second month following purchase ..... 5%If purchases for April, May and June were P200,000; P160,000; and P250,000,respectively, what was the firm’s budgeted payable balance on June 30? 5. Nopat Compano. Has two divisions, Nopat and Compano that reported the following results for May: Division Nopat Division CompanoSales P 90,000 P 150,000Variable expenses (% of sales) 70% 60%Segment margin 2,000 23,000If common expenses were P31,000, what must have been the total fixed costs? 6. A company’s average operating assets are P220,000 and its net operating income isP44,000. The company invested in new project, increasing average assets to P250,000 andincreasing net operating income to P49,550. What is the project’s residual income if therequired rate of return is 20%? Provide…
Use this information about Nuthatch Corporation to answer the question that follows. Nuthatch Corporation began its operations on September 1 of the current year. Budgeted sales for the first 3 months of business-September, October, and November-are $249,000, $320,000, and $425,000, respectively. The company expects to sell 30% of its merchandise for cash. Of sales on account, 80% are expected to be collected in the month of the sale and 20% in the month following the sale. The cash collections expected in October from accounts receivable are estimated to be a. $256,872 b. $144,340 c. $179,200 d. $214,060
Mungus Coffee has recently recruited you to assist them with the financial aspect of their business. One component of your job is prepare budgets. The Income Statement for last year is presented below and you are required to create a Proforma Income Statement for July 31st 2021 using the fixed variable method. The company expects Sales to increase by 5%. Mungus Coffee Income Statement For the period July 31st 2020 Sales 126,000 Less Cost of Goods Sold 54,000 (variable) Gross Profit 72,000 Less Operating Expenses: Marketing Expense 28,400 (6000 variable and 22,400 fixed) General and Admin. Expense 8,600 (3000 variable and 5,600 fixed) Total Operting Expense 37,000 Operating Income 35,000 Less Interest Expense 1,800 (fixed)…
The management accountant at Miller Merchandising & More, Odail Russell is in the process of preparing the cash budget for the business for the fourth quarter of 2021. It is customary for thebusiness to borrow money during this quarter. Extracts from the sales and purchases budgets areas follows:Month cash sales sales on account purchasesAugust $85,000 $640,000 $420,000September $70,000 $550,000 $550,000October $88,550 $600,000 $500,000November $77,160 $800,000 $600,000December $174,870 $500,000 $450,000 i) An analysis of the records shows that trade receivables are settled according to the following credit pattern, in accordance with the credit terms 4/30, n90:50% in the month of sale30% in the first month following the sale20% in the second month…
The management accountant at Miller Merchandising & More, Odail Russell is in the process of preparing the cash budget for the business for the fourth quarter of 2021. It is customary for the business to borrow money during this quarter. Extracts from the sales and purchases budgets are as follows: i) An analysis of the records shows that trade receivables are settled according to the following credit pattern, in accordance with the credit terms 4/30, n90:50% in the month of sale30% in the first month following the sale20% in the second month following the sale ii) Expected purchases include monthly cash purchases of 5%. All other purchases are on account. Accounts payable are settled as follows, in accordance with the credit terms – 2/30, n60:60% in the month in which the inventory is purchased40% in the following month iii) Fixed operating expenses which accrue evenly throughout the year, are estimated to be $1,680,000 per annum, (including depreciation on non-current assets of…