Hi, I need help solving for the remaining values (cells highlighted red require input; white numerical cells are dynamic). Thank you.
Q: Required: 1. and 2. Determine the cost of batteries that would appear in each of the following…
A: COST OF INVENTORY Cost of inventory are the cost of those inventory which is left at the end of…
Q: Espresso Express operates a number of espresso coffee stands in busy suburban malls. The fixed…
A: Sales or manufacturing volume fluctuations have no effect on fixed costs, which are outlaid that…
Q: In recording adjusting entries, Reagan Financial Advisors failed to record the adjusting entries for…
A: According to the given question, we are required to prepare the statement of adjusting entries that…
Q: Alanco, Inc. manufactures a variety of products and is currently maunfacturing all of its own…
A: Make or buy is the decision making analysis that helps the entity to decide whether the goods should…
Q: Sierra Company produces its product at a total cost of $100 per unit. Of this amount, $30 per unit…
A: The markup amount is the excess amount charged from customers as compared to base cost for the…
Q: udson Company reports the following contribution margin income statement. HUDSON COMPANY…
A: Breakeven calculation is important analysis done in cost volume profit analysis. Breakeven point is…
Q: Calculate the missing amounts. BrambleLtd. SheffieldLtée Sales $88,200 $100,800 Cost of goods sold…
A: Net income is the excess value of revenue over the expenses, It is calculated through an income…
Q: Exercise 8-8 (Algo) Record payroll (LO8-3) During January, Luxury Cruise Lines incurs employee…
A: JOURNAL ENTRIES Jounal entry is the First stage of Accounting Procedure. Journal entry is help…
Q: Siberia. The cost of the musk oil is $1.50 per gram. Budgeted production of Mink Caress is given…
A: Direct materials purchase budget is based on production needs and is prepared to predict the…
Q: Sanders Clinics provides health services and career counseling. Net income from the health services…
A: Income statement: Income statement is the financial statement that shows the organization's…
Q: 3. Nine years ago, Beatrice invested a sum of $6,000. The interest rate she earned changed over…
A: The value of investment at a given interest rate for a period is given by the formula A = P *…
Q: Fickel Company has two manufacturing departments-Assembly and Testing & Packaging. The predetermined…
A: The entire cost of all resources used to produce a good is known as the manufacturing cost. The…
Q: Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur…
A: SHEDULE OF COLLECTION FROM CUSTOMER Schedule of Collection From Sales States the amount of Cash…
Q: The management of Mecca Copy, a photocopying center located on University Avenue, has compiled the…
A: Balance sheet is one of financial statements which includes assets and liabilities. Total of assets…
Q: What is the full equation or data points used for the IRR? The last part is cut off. I have attached…
A: Internal rate of return (IRR) is the discount rate at which NPV of the project is zero. NPV=Initial…
Q: Using the following data for Ace Guitar Company: A Region Sales Cost of goods sold Selling expenses…
A: Operating income refers to the adjusted revenue of a company after all expenses of operation and…
Q: 1. Present Value (PV Enter the interest rate in the highlighted cell below. Use the cash flows below…
A: Present value is the current date value of all future cash flows discounted over a period of…
Q: Function: SUM; Formula: Add, Subtract; Cell Referencing Using Excel to Calculate Operating Cash…
A: Cash Flow from Operating Activities: Cash Flow from Operating Activities are the section of cash…
Q: What is the result of inputting =IF(S>9,ok,error) into a cell? #NAME? ok 5. error
A: If function is used to validate a statement. And it gives an output according to the validation.
Q: head $198,000 (budgeted and actual amount) 3,240 yards hours at $6.25 per yard 23,400 hours at…
A: The income statement is prepared by the business organizations so as to know how much amount of…
Q: Ivanov Co. had 1,000 units in beginning WIP inventory on September 1, which were 30% complete with…
A: EQUIVALENT UNITS OF PRODUCTION Equivalent Production is represents the production of a process in…
Q: A B 14 1. Compute the CM ratio and variable expense ratio. 15 Selling price per unit 16 Variable…
A: Contribution Margin :— It is the difference between sales revenue and total variable cost. Net…
Q: Annual Interest Payment: PV of Face Value: +PV of Interest Payments: =Bond Selling Price: $…
A: The bond is said to be issued at discount if the selling price if less than face value and at…
Q: Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management has…
A: The cash budget is prepared to record the cash receipts and cash payments for the period. The cash…
Q: New Scenario (Independent): Brian takes out a home loan of $473,800 today. He wants to make equal…
A: Loans are paid by annual payments and these payments carry the payment for interest and loan…
Q: Cherokee Incorporated is a merchandiser that provided the following information: Number of units…
A: Calculation of Cost of goods sold: Beginning merchandise inventory $8,000 Add: Merchandise…
Q: Oficina Bonita Company manufactures office furniture. An unfinished desk is produced for $34.35 and…
A: Differential analysis is performed to scrutinize the changes in revenue, costs, and profits. It…
Q: Sleep Tight, Inc., manufactures comforters. The estimated Inventories on January 1 for finished…
A: The "direct cost" incurred in the production of any goods or services is measured by the cost of…
Q: me how to calculate this without using excel? Thanks
A: A mortgage payment is a regular commitment that a borrower makes to a lender in order to pay back a…
Q: An engineering firm spent $160,000 to purchase and install new computer equipment in its office. The…
A: Depreciation is a non-cash expense that is incurred due to the continuous use of the fixed assets.…
Q: Stockholders' Equity: Transactions and Statement The stockholders' equity section of Night…
A: It is the first step to record the financial transactions in the books of accounts that has dual…
Q: Presented below is a partial amortization schedule for a three-year installment note requiring…
A: Loans are paid by equal monthly payments and these monthly payments carry the payment for interest…
Q: Using Excel to Determine the Adjusted Cash Balance PROBLEM For the month of August, Pratt Company…
A: Adusted cash book is prepared to find the discrepancy in the transactions which may happen during…
Q: the answer i am looking for in this problem is in yellow but ill write it here too. 1. The scenario…
A: Answer: Let us do the scenario analysis Let check what will the total profit in likely situation if…
Q: Finch Company began its operations on March 31 of the current year. Finch has the following…
A: A cash payment is bills or coins paid by the recipient of goods or services to the provider. It can…
Q: Melton Manufacturing Ltd is considering two alternative investment projects. The first project calls…
A: Net present value is sum of present value of cash flows at a given discount rate. IRR is the…
Hi,
I need help solving for the remaining values (cells highlighted red require input; white numerical cells are dynamic).
Thank you.
Step by step
Solved in 2 steps
- One Device makes universal remote controls and expects to sell 500 units in January, 800 in February, 450 in March, 550 in April, and 600 in May. The required ending inventory is 20% of the next months sales. Prepare a production budget for the first four months of the year.A companys sales for the coming months are as follows: About 20 percent of sales are cash sales, and the remainder are credit sales. The company finds that typically 10 percent of a months credit sales are paid in the month of sale, 70 percent are paid the next month, and 15 percent are paid in the second month after sale. Expected cash receipts in July are budgeted at what amount? a. 114,520 b. 143,150 c. 145,720 d. 156,000The data shown were obtained from the financial records of Italian Exports, Inc., for March: Sales are expected to increase each month by 10%. Prepare a budgeted income statement.
- Palmgren Company produces consumer products. The sales budget for four months of the year is presented below. Company policy requires that ending inventories for each month be 25 percent of next months sales. At the beginning of July, the beginning inventory of consumer products met that policy. Required: Prepare a production budget for the third quarter of the year. Show the number of units that should be produced each month as well as for the quarter in total.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?Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the follow sales: In Shalimars experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are 4,900,000 and for the fourth quarter of the current year are 6,850,000. Required: 1. Calculate cash sales and credit sales expected in the last two quarters of the current year, and in each quarter of next year. 2. Construct a cash receipts budget for Shalimar Company for each quarter of the next year, showing the cash sales and the cash collections from credit sales. 3. What if the recession led Shalimars top management to assume that in the next year 10 percent of credit sales would never be collected? The expected payment percentages in the quarter of sale and the quarter after sale are assumed to be the same. How would that affect cash received in each quarter? Construct a revised cash budget using the new assumption.
- Rehydrator makes a nutrition additive and expects to sell 3,000 units in January, 2,000 in February, 2,500 in March, 2,700 in April. and 2,900 in May. The required ending inventory is 20% of the next months sales, and the beginning inventory on January 1 was 600 units. Prepare a production budget for the first four months of the year.Pasadena Candle Inc. projected sales of 800,000 candles for January. The estimated January 1 inventory is 35,000 units, and the desired January 31 inventory is 20,000 units. What is the budgeted production (in units) for January?Operating Budget, Comprehensive Analysis Allison Manufacturing produces a subassembly used in the production of jet aircraft engines. The assembly is sold to engine manufacturers and aircraft maintenance facilities. Projected sales in units for the coming 5 months follow: The following data pertain to production policies and manufacturing specifications followed by Allison Manufacturing: a. Finished goods inventory on January 1 is 32,000 units, each costing 166.06. The desired ending inventory for each month is 80% of the next months sales. b. The data on materials used are as follows: Inventory policy dictates that sufficient materials be on hand at the end of the month to produce 50% of the next months production needs. This is exactly the amount of material on hand on December 31 of the prior year. c. The direct labor used per unit of output is 3 hours. The average direct labor cost per hour is 14.25. d. Overhead each month is estimated using a flexible budget formula. (Note: Activity is measured in direct labor hours.) e. Monthly selling and administrative expenses are also estimated using a flexible budgeting formula. (Note: Activity is measured in units sold.) f. The unit selling price of the subassembly is 205. g. All sales and purchases are for cash. The cash balance on January 1 equals 400,000. The firm requires a minimum ending balance of 50,000. If the firm develops a cash shortage by the end of the month, sufficient cash is borrowed to cover the shortage. Any cash borrowed is repaid at the end of the quarter, as is the interest due (cash borrowed at the end of the quarter is repaid at the end of the following quarter). The interest rate is 12% per annum. No money is owed at the beginning of January. Required: 1. Prepare a monthly operating budget for the first quarter with the following schedules. (Note: Assume that there is no change in work-in-process inventories.) a. Sales budget b. Production budget c. Direct materials purchases budget d. Direct labor budget e. Overhead budget f. Selling and administrative expenses budget g. Ending finished goods inventory budget h. Cost of goods sold budget i. Budgeted income statement j. Cash budget 2. CONCEPTUAL CONNECTION Form a group with two or three other students. Locate a manufacturing plant in your community that has headquarters elsewhere. Interview the controller for the plant regarding the master budgeting process. Ask when the process starts each year, what schedules and budgets are prepared at the plant level, how the controller forecasts the amounts, and how those schedules and budgets fit in with the overall corporate budget. Is the budgetary process participative? Also, find out how budgets are used for performance analysis. Write a summary of the interview.
- Cash budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent 50,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. Current assets as of September 1 include cash of 40,000, marketable securities of 75,000, and accounts receivable of 300,000 (60,000 from July sales and 240,000 from August sales). Sales on account for July and August were 200,000 and 240,000, respectively. Current liabilities as of September 1 include 40,000 of accounts payable incurred in August for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of 55,000 will be made in October. Bridgeports regular quarterly dividend of 25,000 is expected to be declared in October and paid in November. Management desires to maintain a minimum cash balance of 50,000. Instructions Prepare a monthly cash budget and supporting schedules for September, October, and November. On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?Sunrise Poles manufactures hiking poles and is planning on producing 4,000 units in March and 3,700 in April. Each pole requires a half pound of material, which costs $1.20 per pound. The companys policy is to have enough material on hand to equal 10% of the next months production needs and to maintain a finished goods inventory equal to 25% of the next months production needs. What is the budgeted cost of purchases for March?Play-Disc makes Frisbee-type plastic discs. Each 12-inch diameter plastic disc has the following manufacturing costs: For the coming year, Play-Disc expects to make 300,000 plastic discs, and to sell 285,000 of them. Budgeted beginning inventory in units is 16,000 with unit cost of 4.75. (There are no beginning or ending inventories of work in process.) Required: 1. Prepare an ending finished goods inventory budget for Play-Disc for the coming year. 2. What if sales increased to 290,000 discs? How would that affect the ending finished goods inventory budget? Calculate the value of budgeted ending finished goods inventory.