Xercise Cycles Company has provided its year ended accounts receivables that were uncollected. The Controller has asked you to help prepare the Aging of Accounts Receivable Schedule and the corresponding journal entries. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. 1) Calculate the number of days unpaid, USING THE EXCEL DAYS FUNCTION (fx).
2) Use the information above to complete the Aging of Accounts Recievable Schedule Below.
Create a formula for each age category, using the Excel IF and AND FUNCTION (fx) to determine where each customer amount belongs.
3) Prepare the adjusting journal entry for recording bad debt expense if the allowance for doubtful accounts had the following unadjusted balance:
4) Prepare the adjusting journal entry for recording bad debt expense if the Allowance for Doubtful Accounts had the following unadjusted balance:

It is week 1 and there are currently 20 as in stock. we need 300 as at the start of week 5. if there are scheduled receipts planned for week 3 and week 4 of 120 as each and a has a lead time of 1 week, when and how large of an order should be placed to meet the requirement of 300 as?

Anewspaper boy is trying to perfect his business in order to maximize the money he can save for a new car. daily paper sales are normally distributed, with a mean of 100 and standard deviation of 10. he sells papers for $0.50 and pays $0.30 for them. unsold papers are trashed with no salvage value. how many papers should he order each day and what % of the time will he experience a stockout? are there any drawbacks to the order size proposed and how could the boy address such issues?

Ida sidha karya company is a family-owned company located on the island of bali in indonesia. the company produces a handcrafted balinese musical instrument called a gamelan that is similar to a xylophone. the gamelans are sold for $860. selected data for the company’s operations last year follow: units in beginning inventory 0 units produced 320 units sold 285 units in ending inventory 35 variable costs per unit: direct materials $ 135 direct labor $ 355 variable manufacturing overhead $ 30 variable selling and administrative $ 15 fixed costs: fixed manufacturing overhead $ 64,000 fixed selling and administrative $ 27,000 the absorption costing income statement prepared by the company’s accountant for last year appears below: sales $ 245,100 cost of goods sold 205,200 gross margin 39,900 selling and administrative expense 31,275 net operating income $ 8,625 required: 1. under absorption costing, how much fixed manufacturing overhead cost is included in the company's inventory at the end of last year? 2. prepare an income statement for last year using variable costing. what is the amount of the difference in net operating income between the two costing methods?