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

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Munoz Company is a retail company that specializes in selling outdoor camping equipment. The company is considering opening a new store on October 1, year 1. The company president formed a planning committee to prepare a master budget for the first three months of operation. As budget coordinator, you have been assigned the following tasks. Required a. October sales are estimated to be $340,000, of which 40 percent will be cash and 60 percent will be credit. The company expects sales to increase at the rate of 20 percent per month. Prepare a sales budget. b. The company expects to collect 100 percent of the accounts receivable generated by credit sales in the month following the sale. Prepare a schedule of cash receipts. c. The cost of goods sold is 70 percent of sales. The company desires to maintain a minimum ending inventory equal to 20 percent of the next month's cost of goods sold. However, ending inventory of December is expected to be $12,900. Assume that all purchases are made…
At the beginning of the school year, Katherine Malloy decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget: \table[[Cash balance, September 1 (from a summer job), $8, 430 At the beginning of the school year, Katherine Malloy decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget: \table[[Cash balance, September 1 (from a summer job), $8,430
The Hubbard Corporation is a distributor of hair care products and is ready to start the third quarter, in which its peak sales occur. The company has requested a $100,000, 90-day loan from its bank to help them meet their cash requirements for the third quarter. Since Hubbard Corporation has experienced difficulty in paying off their loans in previous years, the loan officer has requested the company prepare a cash budget for the third quarter. The following data has been gathered by the staff. On July 1, 2021, the beginning of the third quarter, the company will have a cash balance of $75,000. Actual sales for the last 2 months and budgeted sales for the third quarter (all sales are on account). Month Amount in Dollars ($) May (actual) 500,000 June (actual) 480,000 July (budgeted) 520,000 August (budgeted) 550,000 September (budgeted) 600,000 Past experience shows that 30% of a month's sales are collected in the month of sale, 60% in the month…
At the beginning of the school year, Katherine Malloy decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget: Cash balance, September 1 (from a summer job) $7,180 Purchase season football tickets in September 100 Additional entertainment for each month 250 Pay fall semester tuition in September 3,900 Pay rent at the beginning of each month 350 Pay for food each month 200 Pay apartment deposit on September 2 (to be returned December 15) 500 Part-time job earnings each month (net of taxes) 890 a. Prepare a cash budget for September, October, November, and December. Enter all amounts as positive values except an overall cash decrease which should be indicated with a minus sign. b. Are the four monthly budgets that are presented prepared as static…
Pelican Merchandising & More is a family-owned store. The business is now approaching the end of the year and is in the process of identifying its cash needs for the first quarter of the new year. You are the management accountant of the entity and have been tasked to prepare the cash budget for the business for the quarter ending March 31, 2022. (i) Extracts from the sales and purchases budgets are as follows:Month2021 - 2022CashSalesSalesOn AccountCashPurchasesPurchasesOnAccountNovember 2021 $138,100 $480,000 $345,000December 2021 $156,500 $600,000 $25,800 $380,000January 2022 $170,975 $650,000 $44,625 $400,000February 2022 $135,740 $700,000 $30,400 $480,000March 2022 $226,420 $800,000 $55,100 $540,00 A schedule of expected cash disbursements for accounts payable (purchases on account) for each of the months January to March.
L & P Merchandising & More is a family-owned furniture store. You are the management accountant of the concern and have been given the task of preparing the cash budget for the business for the quarter ending December 31, 2020. Your data collection has yielded the following: (1) Extracts from the sales and purchases budgets are as follows: Month Cash Sales On Purchases 2020 Sales On Account Account August September October $121,000 $95,500 $480,000 $600,000 $390,000 $360,000 $132,680 $105,900 $720,000 $650,000 $480,000 $400,000 November December $216,000 $800,000 $500,000 (ii) An analysis of the records shows that trade receivables (accounts receivable) are settled according to the following credit pattern, in accordance with the credit terms 5/30, n90: 60% in the month of sale 30% in the first month following the sale 10% in the second month following the sale (iii) Accounts payable are settled as follows, in accordance with the credit terms 3/30, n60: 80% in the month in which the…
The Hubbard Corporation is a distributor of hair care products and is ready to start the third quarter, in which its peak sales occur. The company has requested a $100,000, 90-day loan from its bank to help them meet their cash requirements for the third quarter. Since Hubbard Corporation has experienced difficulty in paying off their loans in previous years, the loan officer has requested the company prepare a cash budget for the third quarter. The following data has been gathered by the staff. On July 1, 2021, the beginning of the third quarter, the company will have a cash balance of $75,000. Actual sales for the last 2 months and budgeted sales for the third quarter (all sales are on account). Month Amount in Dollars ($) May (actual) 500,000 June (actual) 480,000 July (budgeted) 520,000 August (budgeted) 550,000 September (budgeted) 600,000 Past experience shows that 30% of a month's sales are collected in the month of sale, 60% in the month…
At the beginning of the school year, Katherine Malloy decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget: Cash balance, September 1 (from a summer job) $6,540 Purchase season football tickets in September 90 Additional entertainment for each month 230 Pay fall semester tuition in September 3,500 Pay rent at the beginning of each month 320 Pay for food each month 180 Pay apartment deposit on September 2 (to be returned December 15) 500 Part-time job earnings each month (net of taxes) 810 a. Prepare a cash budget for September, October, November, and December. Enter all amounts as positive values except an overall cash decrease which should be indicated with a minus sign. KATHERINE MALLOY Cash Budget For the Four Months Ending December…
The treasurer of U Co. has accumulated the budget information presented in the table for the months of March and April pertaining to cash payments. Forty percent of the merchandise costs are expected to be paid in the month they are incurred and the remaining sixty percent in the following month. All of the operating expenses are paid for by cash in the month they are incurred. The accounts payable balance on March 1 is $60,000. What is the amount to include in the Cash Budget for the month of April for the Merchandise Costs (which does include the balance from March + Cost for April)? MARCH APRIL Merchandise costs $120,000 $132,000 Operating expenses 100,000 110,000
Glamor Household Furnishings & Appliances is a family-owned furniture store. You are the management accountant of the concern and have been given the task of preparing the cash budget for the business for the quarter ending September 30, 2018. Your data collection has yielded the following: i) Extracts from the sales and purchases budgets are as follows: Month Cash Sales Sales On Account Purchases On Account May $50,000 $480,000 $390,000 June $65,000 $600,000 $360,000 July $43,400 $720,000 $450,000 August $52,800 $640,000 $400,000 September $56,750 $800,000 $500,000 ii) An analysis of the records shows that trade receivables (accounts receivable) for sales on account are settled according to the following credit pattern, in accordance with the credit terms 5/30, n90: 50% in the month of sale 35% in the first month following the sale 15% in the second month following the sale iii) Accounts payable are settled as follows, in accordance with the credit terms – 4/30, n60: 70% in the…
The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: May: Sales 116,000 Manufacturing Costs 49,000 Selling and administrative expenses 34,000 Capital expenditures - June: Sales 143,000 Manufacturing costs 61,000 Selling and administrative expenses 39,000 Capital expenditures - July: Sales 186,000 Manufacturing Costs 67,000 Selling and administrative expenses 41,000 Capital expenditures 45,000 The company expects to sell about 15% of his merchandise for cash of sales account 65% are expected to be collected in the month following the sale and the remainder of the following month (second month following sale). Depreciation, insurance, and property tax expense represent $6,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in September, and the annual property taxes are paid in November. Of the remainder of the manufacturing costs, 80%…