Mountain Press proauces textbooks for high school accounting courses. The company recently hired a new editor, Jan Green, to handle production and sales of books for an introductory accounting course. Jan's compensation depends on the gross margin associated with sales of this book. Jan needs to decide how many copies of the books to produce. The following information is available for the fall semester of 2017: Estimated sales 50,000 books O books $ 160 per book $ 100 per book $750,000 per semester The fixed-cost allocation rate is based on expected sales and is therefore equal to $750,000/50,000 books = $15 per book. Beginning inventory Average selling price Variable production costs Fixed production costs Jan has decided to produce either 50,000, 65,000, or 70,000 books.

Mountain Press proauces textbooks for high school accounting courses. The company recently hired a new editor, Jan Green, to handle production and sales of books for an introductory accounting course. Jan's compensation depends on the gross margin associated with sales of this book. Jan needs to decide how many copies of the books to produce. The following information is available for the fall semester of 2017: Estimated sales 50,000 books O books $ 160 per book $ 100 per book $750,000 per semester The fixed-cost allocation rate is based on expected sales and is therefore equal to $750,000/50,000 books = $15 per book. Beginning inventory Average selling price Variable production costs Fixed production costs Jan has decided to produce either 50,000, 65,000, or 70,000 books.

Name: Calculate ending inventory in units and in dollars for each production
Uploaded: 2024-03-20T06:32:37.000Z
Channel: Bartleby
Description: Calculate ending inventory in units and in dollars for each production level. Mountain Press proauces textbooks for high school accounting courses. The company recently hireda new editor, Jan Green, to handle production and sales of books for an intr

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter21: Cash Budgeting (cashbud)

Section: Chapter Questions

Problem 1R: On January 1, Sweet Pleasures, Inc., begins business. The company has 14,000 cash on hand and is...

See similar textbooks

Similar questions

John’s Publishing Company, a new service that writes term papers for college students, provides 11-page term papers from a list of more than 500 topics. Each paper will cost $7.50 and is written by a graduate in the topic area. John’s will pay $20,000 for the rights to all of the manuscripts. In addition, each author will receive $0.50 in royalties for every paper sold. Marketing expenses are estimated to be a total of $20,000 divided equally between Years 1 and 2, and John’s cost of capital is 11 percent. Sales are expected as follows: a. What is the payback period for this investment? Its NPV? Its IRR? b. What are the ethical implications of this investment?
Betta Jets, a toy wholesaler, is hoping to expand into manufacturing its own products. The business owners have provided you with the following information: All sales are on credit. The company collects 70% in the month following the sale and 30% two months following the sale. All purchases of stock are paid for one month after the purchase. Equipment costing $250,000 is expected to be acquired and paid for in July. The selling and distribution expenses are $48 000 each month. Administrative expenses are $42 000 per month. This includes $5 000 of depreciation expense. Selling Expenses and Administrative Expenses are paid in the month they are incurred. The cash balance on 1 July 2022 is $28 000. The following sales and purchases data in 2022 have been compiled for the preparation of the budget: April May June July $ $ $ $ Purchases 300 000 360 000 340 000 400 000 Sales 800 000 860 000 840 000 880 000 REQUIRED: Prepare…
A new book publishing and sales project estimates that the first year 7,000 printed units and 2,000 digital units will be sold.The printer will charge them $5 for each book.The publisher will sell the books for $12 each.The virtual books will be sold for $6 through a platform and the publisher receives $3.The authors of the books receive 5% of the sales made by the publisher, whether online or in print, which is recorded as an expense. The market study suggests that sales of printed books can increase at 20% per year and those of digital format at 30% per year.The initial equipment will be reduced, since they work with the subcontracting of printed material. Basically, they include computer equipment, software and furniture that have a value of 20,000; In addition, a vehicle will be purchased for a value of 15,000. Computer equipment, software and furniture are depreciated instraight line in 5 years. In year 6, these equipments must be bought again for the same value.The vehicle is…
Party-Time T-Shirts sells T-shirts for parties at the local college. The company com plated the first year of operations, and the shareholders are generally pleased with operating results as shown by the following income statement: Bill Hildebrand, the controller, is considering how to expand the business. He proposes two ways to increase profits to $100,000 during 2018. a. Hildebrand believes he should advertise more heavily. He believes additional advertising costing 320,000 will increase net sales by 30% and leave administrative expense unchanged. Assume that Cost of Goods Sold will remain at the same percentage of net sales as in 2017, so if net sales increase in 2018, Cost of Goods Sold will increase proportionately. b. Hildebrand proposes selling higher-margin merchandise, such as party dresses, in addition to the existing product line. An importer can supply a minimum of 1,000 dresses for $40 each; Party-Time can mark these dresses up 100% and sell them for $80. Hildebrand…
A home gods retailer offers a sales incentive program where customers receive credit towards future purchases based on the dollar amount of their purchases today. For every $10 spent, a customer receives a $1 credit to use in the next 30 days. Based upon historical trends, the firm estimates that 35% of the credits will be redeemed. In the next month, consistent with the firm’s estimate, 35% of the credits were redeemed. The entry recorded to account for the redemption of these credits (excluding the effect of the costs of sales entry): A.) Increases Liabilities, Increases Stockholders’ Equity B.) Increases Liabilities, Reduces Stockholders’ Equity C.) Reduces Liabilities, Reduces Stockholders’ Equity D.) Reduces Liabilities, Increases Stockholders’ Equity C.) No entry needed
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.
Ethics and Sales Returns At the end of 2019, the accounting firm for which you work is auditing the books of Debitus Publishing Inc. for the first time. Debitus, a calendar year company, publishes textbooks that are used in colleges and universities across the country. These textbooks are purchased by students through their campus bookstores. Debitus normally makes its biggest sales at the beginning of the fall semester. In the past, Debitus has always recorded sales returns in the spring semester when the campus bookstores return any unsold textbooks. This has been satisfactory because the returns have been immaterial in amount. In 2018, as a promotional strategy to stimulate sales, Debitus began offering bookstores a reduced price if they ordered more textbooks. There is no penalty for returns of these textbooks if the bookstores cannot sell them to customers. This strategy worked; sales increased by 10% during 2018. In early 2019, however, a substantial amount of unsold textbooks were returned by bookstores to Debitus. Continuing the promotional strategy, sales increased by 15% during 2019. While reviewing the sales returns account for 2019, you notice that the only entry was for the textbooks returned earlier in the year. You note that these returns amounted to about 5% of the sales for the fall semester of 2018. Because this pattern of returns seems to you to be a trend that will continue, you raise the issue with the company controller as to whether all of the sales for the fall semester of 2019 are actually revenue. The controller responds, Of course tiiey are revenue; we sold the textbooks. Just because there will some returns doesnt mean we havent made sales. Besides, we dont know what percentage the returns will be. They might be as much as 5%, but definitely not more. Furthermore, we have already recorded all those returns at the beginning of 2019 that really applied to 2018. So we already have recorded our fair share of returns for 2019. As long as we record returns consistently, it will all work out. We dont want a drop in earnings for 2019 because of a change in customer returns, our shareholders wouldnt like that. Lets just leave this issue alone. Required: From financial reporting and ethical perspectives, what do you think about Debituss policy in regard to sales returns?
Rather than going directly to college, some students take time off to travel abroad, learn new skills, or volunteer. This period is known as a gap year Real Gap Experience provides hundreds of gap year traveling opportunities in over 45 countries around the world. The company offers everything from volunteering to building houses in Guatemala to teaching in China (for pay) to taking a year-long, around-the-world trip. What does this have to do with accounting, and why is it important? Every company needs to keep a record of its financial activities so that financial statements can be presented and used for decision making. Real Gap Experiences accounting records are most likely computerized, but the company still needs to go through the closing process. Why is the closing process important to a company such as Real Gap Experience? What types of accounts would be used during the closing process for this company?
On December 1, 2019, AwakcAllNight Inc. sells 5,000 super caffeinated candy bars to Campus Grocers. The candy bars sell for 3 per bar. In addition, AwakcAllNight pays Campus Grocers a 900placement fee to ensure that its candy bars are always stocked prominently by the cash register. The 900 is paid at the end of each month based on the results of random inspections of Campus Grocers by AwakcAllNight to ensure that the terms of the contract are being followed. Required: 1. Determine the transaction price for Awake AllNights revenue contract. 2. Prepare AwakeAllNights journal entries to recognize sales revenue and pay Campus Grocers the placement fee.
You have just begun your summer internship at Omni Instruments. The company supplies sterilized surgical instruments for physicians. To expand sales, Omni is considering paying a commission to its sales force. The controller, Matthew Barnhill, asks you to compute: (1) the new breakeven sales figure, and (2) the operating profit if sales increase 15% under the new sales commission plan. He thinks you can handle this task because you learned CVP analysis in your accounting class. You spend the next day collecting information from the accounting records, performing the analysis, and writing a memo to explain the results. The company president is pleased with your memo. You report that the new sales commission plan will lead to a significant increase in operating income and only a small increase in breakeven sales. The following week, you realize that you made an error in the CVP analysis. You overlooked the sales personnel’s $2,800 monthly salaries, and you did not include this fixed…
Good morning, Can you please do this in excel? Thanks SOUND CORE WIRELESS sells a variety of mobile telephone accessories including several brands ofWireless Earbuds Bluetooth Headphones. The earbuds are sold in cases, with each case containing a pair ofearbuds. SOUND CORE began the last quarter (October to December) of 2021 with 30 cases of the (TOZOT6) earbuds at a total cost of $187,800. During the quarter the business completed the following transactionsrelating to the “TOZO T6” earbuds: October 8 98 cases were purchased at a cost of $6,202 each. In addition, the business paid a freight charge of $248 cash on each case to have the inventory shipped from the point of purchase to their place of business. October 31 The sales for October were 85 cases which yielded total sales revenue of $809,030. (25 of these cases were sold on account to three longstanding customers)…
A home gods retailer offers a sales incentive program where customers receive credit towards future purchases based on the dollar amount of their purchases today. For every $10 spent, a customer receives a $1 credit to use in the next 30 days. Based upon historical trends, the firm estimates that 35% of the credits will be redeemed. Assume the credit associated with the sales incentive program is a separate performance obligation. If during the month the company sold $40,000 of product with a cost of $22,000, what is amount of revenue allocated to product sales? Round to the nearest dollar. $29,630 $36,364 $38,647 $40,000 None of the above