Create a PivotChart of Total Sales by Product Group. Insert this chart in a chart sheet. Rename this chart sheet as Sales by Product Group. Create a second PivotChart of total Sales by Territory. Change the chart type to Pie and follow the attached layout. Insert this chart in a chart sheet. Rename this chart sheet as Sales by Territory. Product
AutomotiveVancouverNov201899526
AutomotiveWashingtonJan201899258
AutomotiveOregonAug201898358
ElectronicsVancouverApr201898044
GardeningVancouverJul201897793
GardeningWashingtonApr201797502
ElectronicsVancouverJun201797282
AutomotiveOregonSep201797203
GardeningWashingtonJun201796897
SportingWashingtonApr201796601
AutomotiveWashingtonAug201896102

Wilson center is a private not-for-profit voluntary health and welfare entity. during 2017, it received unrestricted pledges of $638,000, 65 percent of which were payable in 2017, with the remainder payable in 2018 (for use in 2018). officials estimate that 14 percent of all pledges will be uncollectible. a. how much should wilson center report as contribution revenue for 2017? b. in addition, a local social worker, earning $20 per hour working for the state government, contributed 600 hours of time to wilson center at no charge. without these donated services, the organization would have hired an additional staff person. how should wilson center record the contributed service?

Consider a treasury bill with a rate of return of 5% and the following risky securities: security a: e(r) = .15; variance = .0400 security b: e(r) = .10; variance = .0225 security c: e(r) = .12; variance = .1000 security d: e(r) = .13; variance = .0625 the investor must develop a complete portfolio by combining the risk-free asset with one of the securities mentioned above. the security the investor should choose as part of her complete portfolio to achieve the best cal would be a. security a b. security b c. security c d. security d

Selected t-account balances for bloomfield company are shown below as of january 31, which reflect its accounting adjustments. the firm uses a calendar-year accounting period, but prepares monthly accounting adjustments. suppliesjan. 31 bal. 1,800 1,800 jan. 31 bal. supplies expensejan. 31 bal. 1,920 1,148 jan. 31 bal. prepaid insurancejan. 31 bal. 1,148 1,148 jan. 31 bal. insurance expensejan. 31 bal. 164 164 jan. 31 bal. wages payablejan. 31 bal. 1,400 1,400 jan. 31 bal. wages expensejan. 31 bal. 6,400 6,400 jan. 31 bal. truckjan. 31 bal. 17,376 17,376 jan. 31 bal. accumulated depreciation -truckjan. 31 bal. 5,068 5,068 jan. 31 bal. a. if the amount in supplies expense represents the january 31 adjustment for the supplies used in january, and $1,240 worth of supplies were purchased during january, what was the january 1 beginning balance of supplies? $answerb. the amount in the insurance expense account represents the adjustment made at january 31 for january insurance expense. if the original insurance premium was for one year, what was the amount of the premium, and on what date did the insurance policy start? amount of the premium $answerthe policy began on answerjune 1july 1august 1september 1october 1november 1 of the previous year. c. if we assume that no beginning balance existed in either in either wage payable or wage expense on january 1, how much cash was paid as wages during january? $answerd. if the truck has a useful life of four years (or 48 months), what is the monthly amount of depreciation expense, and how many months has bloomfield owned the truck? answermonths