Martin Clothing Company is a retail company that sells hiking and other outdoor gear specially made for the desert heat. It sells to individuals as well as local companies that coordinate adventure getaways in the desert for tourists. The following information is available for several months of the current year:   Month Sales Purchases Cash Expenses Paid May $ 90,000 $ 61,000 $ 20,000 June   123,000   92,000   25,500 July   130,000   112,000   34,500 August   129,000   72,000   35,000     The majority of Martin’s sales (65 percent) are cash, but a few of the excursion companies purchase on credit. Of the credit sales, 35 percent are collected in the month of sale and 65 percent are collected in the following month. All of Martin’s purchases are on account with 50 percent paid in the month of purchase and 50 percent paid the following month.   Required: 1. Determine budgeted cash collections for July and August.       July August Budgeted Cash Collections     2. Determine budgeted cash payments for July and August.         July August Budgeted Cash Payments

Green Earth Landscaping Company provides monthly and weekly landscaping and maintenance services to residential customers in the tri-city area. Green Earth has no variable administrative expense. Fixed administrative expenses for June, July, and August include: Salaries $9,400 Insurance 2,250 Depreciation 4,000 Accounting services 600 Required: Question Content Area 1. Construct an administrative expense budget for Green Earth Landscaping Company for the three summer months. Show total amounts by month and in total for the three-month period. Green Earth Landscaping CompanyAdministrative Expense BudgetFor the Summer Months   June July August Total Salaries $___ $___ $___ $___ Insurance ____ ____ ____ ____ Depreciation ____ ____ ____ ____ Accounting services ____ ____ ____ ____ Total administrative expense $_____ $____ $____ $____   Question Content Area 2. What if Green Earth Landscaping Company's insurance rates increased at the beginning…

C-Cubed had the following information from the end of last year for its Mountain Bikes: Budgeted Bike Sales for October Budgeted Bike Sales for November Budgeted Bike Sales for December Desired Ending Finished Goods Inventory Cash Collected from Sales in November Cash Available on November 1 115 bikes 120 bikes 100 bikes 15% of the following month's unit sales $40,000 $5,000 $25,000 Cash Disbursements in November Interest Received During November Loan Payments Made During November The selling price for the Mountain Bikes is $750. All sales are on credit and all credit sales are collected. Each month's credit sales are collected 20% in the month of sale, 30% in the month following the sale, $500 $8,000 and 50% in the second month following the sale. What is the budgeted accounts receivable balance at the end of December? Multiple Choice $52,500 $97,500 $60,000 $105,000

Show in excel format - 9. The sales for Re - Works Inc., a company that fabricates iron fencing from recycled metals, are all on account. For the first three months of the year, Re - Works management expects the following sales: A table shows Re - Works Inc's sales for January ($120,000), February ($130,000) and March ($140,000). Based on past collection patterns, management expects the following: A table shows Re - Works Inc's collection patterns in the month of February showing month of sale (10%), month after sale (50%), and the remainder - second month after sale (40%). Also, based on past experience, management forecasts that 5 percent of accounts receivable will be uncollectible and will eventually be written off. What are the expected cash receipts for March? 10. With the same sales forecasts as in question 9, Re - Works Inc. management would like to implement some changes to credit policy and credit terms that they believe would change the collection pattern going forward and…

Eliot Sprinkler Systems produces equipment for lawn irrigation. One of the parts used in selected Eliot equipment is a specialty nozzle. The budgeting team is now determining the purchase requirements and monthly cash disbursements for this part. Eliot wishes to have in stock enough nozzles to use for the coming month. On August 1, the company has 16,800 nozzles in stock, although the latest estimate for August production indicates a requirement for only 15,000 nozzles. Total uses of the nozzle are expected to be 14,700 in September and 15,540 in October. Nozzles are purchased at a wholesale price of $8. Eliot pays 25 percent of the purchase price in cash in the month when the parts are delivered. The remaining 75 percent is paid in the following month. Eliot purchased 21,000 parts in July. Required: a. Estimate purchases of the nozzle (in units) for August and September. b. Estimate the cash disbursements for nozzles in August and September.

Determine the number ofsalespeople Wheels needs if it has 1,000 bicycle shopaccounts that need to be called on four times peryear. Each sales call lasts approximately 2.5 hours, andeach sales rep has approximately 1,250 hours per yearto devote to customers.

Take-a-Break Travel Company offers spring break travel packages to college students. Two of its packages, a 7-day, 6-night trip to Cancun and a 5-day, 4-night trip to Jamaica, have the following characteristics: Package Specifications Oceanfront room; number of nights Cancun Jamaica 6 4 Cost Data Meals: Breakfasts Lunches Dinners Scuba diving trips Water skiing trips Airfare (round trip from Miami) Transportation to and from airport 454221 7 69634L 1 1 1 $73/night $10/ea $15/ea $25/ea $93/ea $68/ea $400 (Cancun), $500 (Jamaica) $60 (Cancun), $66 (Jamaica) The Cancun trip sells for $2,100, and the Jamaica trip sells for $1,860, and both packages allow two bags to be checked for free. Required: 1. What are the current profit margins on both trips? 2. Take-a-Break's management believes that it must drop the price of each trip by $118 in order to remain competitive in the market. Recalculate profit margins for both packages at these price levels.

Restaurant A serves lunch and dinner. It is open 5 days a week all year long. The total revenue for the past year was $1,000,000. The manager of Matt's Deli estimates that 52% of its revenue is provided by lunch service and the remainder by dinner service. Matt's has 50 seats, with a seat turnover rate of 7.3 for lunch and 4.8 for dinner. Determine the average check per meal for lunch. Select one: a. $237 b. $653 c. None of the available choices d. $333