Exhibit_11.28_A_Apple_Evaluation_and_Cost_Worksheet.xlsx
XLSX spreadsheet 20 KB Posted
- Attached to
- Tablets (IT)
- Solicitation number
- 0000000669
- Issued by
- Los Angeles County, California
About this file
This is a cost worksheet and evaluation model exhibit for a tablet procurement opportunity (Event ID 0000000669) focused on Apple products. The document outlines specifications for three sizes of Apple tablets: iPad Mini 4 (small), iPad Air 2 (medium), and iPad Pro (large), detailing their technical specifications including screen sizes, operating systems, processors, storage capacity, memory, battery life, and wireless capabilities. The worksheet provides a structured format for bidders to submit pricing information for hardware, accessories/peripherals, warranty services, and value-added services.
The pricing section requires bidders to complete yellow cells only, with figures limited to two decimal places for dollars and whole numbers for percentages. The worksheet includes line items for the three tablet configurations, accessories such as cases, keyboards, and cables, AppleCare+ warranty services, and value-added services including asset tagging, basic imaging, and deployment services. A sample line item shows a 45% contract discount on an iPad Mini 4 with an MSRP of $479.00, resulting in a contract price of $263.45. The worksheet automatically calculates the total evaluated price based on the bidder's inputs across all categories.
View the file
Other files
Show 40 more
50 files listed here. See the rest on GovTribe.
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Cost Worksheet Directions
Cost Worksheet Directions
The Following instructions must be followed when completing the Cost Worksheet.
1) The Bidder will fill out the yellow cells only. All other cells have been locked; any modification of other cells may result in the bid being rejected. Every yellow box must be completed.
2) The Evaluated Total tab displays the total calculated bid price for the relevant Silo derived from the aggregate of the Hardware, Accessories/Peripherals Upgrades, Warranty/Services, and Value Added Services.
3) The Evaluated Total tab is locked and will be populated automatically.
4) Per Section 7.2.5, Pricing/Discount Format, all dollar figures must be entered to no more than two (2) decimal places (i.e., $150.75). All percentages entered shall be whole numbers (i.e., 75%).
Event ID: 0000000669 Tablets Exhibit 11.28A Cost Worksheet Directions
&P of &N 03/23/2016
OEM Apple Evaluation Model
OEM Apple Silo - Evaluation Model
| Size | Model | Screen | Operating System | Processor | Storage | Memory | Battery | Wireless LAN | Warranty |
| Small | iPad Mini 4 | 7.9-inch (Diagonal) LED-Backlit Multi-Touch Display | |||||||
| iOS 9 | |||||||||
| A8 Chip with 64‑bit, with M8 Motion Coprocessor | |||||||||
| 64GB | 2 GB RAM DDR3 | Built-in 23.8 Whr Rechargeable Lithium-Polymer Battery |
Up to 10 hours Battery Life Wi‑Fi model (802.11a/b/g/n); Dual Channel (2.4GHz and 5GHz) and MIMO Bluetooth 4.2
| 1-Year Limited Warranty | ||
| Medium | iPad Air 2 | 9.7-inch (Diagonal) LED-Backlit Multi-Touch Display |
| iOS 9 | ||
| A8X Chip with 64‑bit, with M8 Motion Coprocessor | ||
| 64GB | 2 GB RAM DDR3 | Built-in 27.3 Whr Rechargeable Lithium-Polymer Battery |
Up to 10 hours Battery Life Wi‑Fi model (802.11a/b/g/n/ac); Dual Channel (2.4GHz and 5GHz); HT80 with MIMO Bluetooth 4.2
| 1-Year Limited Warranty | |||
| Large | iPad Pro | 12.9-inch (Diagonal) LED-Backlit Multi-Touch Display | |
| iOS 9 | |||
| A9X Chip with 64‑bit, with M9 Motion Coprocessor | |||
| 128GB | 4 GB RAM DDR3 | Built-in 38.5 Whr Rechargeable Lithium-Polymer Battery | |
| Up to 10 hours Battery Life | Wi‑Fi model |
(802.11a/b/g/n/ac); Dual Channel (2.4GHz and 5GHz); HT80 with MIMO Bluetooth 4.2 1-Year Limited Warranty
&"Arial,Regular"&10Event ID: 0000000669 Tablets &"Arial,Regular"&10Exhibit 11.28A Evaluation Model
&"Arial,Regular"&10Refer to Exhibit 11.28A Cost Worksheet &"Arial,Regular"&10&P of &N &"Arial,Regular"&10 03/23/2016
OEM Apple Cost Worksheet
OEM Apple Silo - Cost Worksheet
Bidder:
OEM Index / MSRP: Index Date:
| Category ID | CLIN | Item Description | Quantity | Manufacturer Part Number | Manufacturer (OEM) | SKU Number | UOM | Quantity in UOM | List Price/MSRP | Contract Discount | Contract Price | Extended Total | |
| Sample | 100 | iPad Mini 4 | 1 | MF544LL/A | Apple, Inc | MF544LL/A | Each | 1 | $479.00 | 45% | $263.45 | $263.45 | |
| Hardware* | 100 | Small Configuration | |||||||||||
| iPad Mini 4 | 1 | Each | 1 | $0.00 | $0.00 | $0.00 | |||||||
| 101 | Medium Configuration | ||||||||||||
| iPad Air 2 | 1 | Each | $0.00 | $0.00 | $0.00 | ||||||||
| 102 | Large Configuration | ||||||||||||
| iPad Pro | 1 | Each | $0.00 | $0.00 | $0.00 | ||||||||
| Accessories / Peripherals Upgrades | 200 | iPad Air 2 Smart Case - Black | 1 | Each | $0.00 | $0.00 | $0.00 | ||||||
| 201 | Apple Wireless Keyboard - English | 1 | Each | $0.00 | $0.00 | $0.00 | |||||||
| 202 | Lightning to USB Cable (1 m) | 1 | Each | $0.00 | $0.00 | $0.00 | |||||||
| 203 | Apple 5W USB Power Adapter | 1 | Each | $0.00 | $0.00 | $0.00 | |||||||
| Warranty / Services | 300 | AppleCare+ Extends your coverage to two years from the original purchase date of your iPad and adds up to two incidents of accidental damage coverage | 1 | Each | $0.00 | $0.00 | $0.00 | ||||||
| Value Added Services | 400 | Asset Tagging | 1 | Each | $0.00 | $0.00 | $0.00 | ||||||
| 401 | Basic Imaging | 1 | Each | $0.00 | $0.00 | $0.00 | |||||||
| 402 | Basic Deployment and Logistics | 1 | Hour | $0.00 | $0.00 | $0.00 | |||||||
| Total Evaluated Price: | $0.00 |
&"Arial,Regular"&10Event ID: 0000000669 Tablets &"Arial,Regular"&10Exhibit 11.28A Cost Worksheet
&"Arial,Regular"&10* Refer to Exhibit 11.28A Evaluation Model &"Arial,Regular"&10&P of &N &"Arial,Regular"&10 03/23/2016
File details come from the government source that posted it. Updated .